web statisticsweb stats Business Phone Systems Tech Talk Forum - VOIP & Cloud Phone Help

Business Phone Systems

Previous Thread
Next Thread
Print Thread
Rate Thread
#250588 04/29/05 06:04 AM
Joined: Mar 2004
Posts: 188
chemcl Offline OP
Member
OP Offline
Member
Joined: Mar 2004
Posts: 188
Anyone know what the command is to load an external document into mysql? I have the script.sql that I spent quite a while typing up but can't remember how to get that to run.


Cheryl McLean
Communications Done Right
Atcom VoIP Phones
VoIP Demo

Best VoIP Phones Canada


Visit Atcom to get started with your new business VoIP phone system ASAP
Turn up is quick, painless, and can often be done same day.
Let us show you how to do VoIP right, resulting in crystal clear call quality and easy-to-use features that make everyone happy!
Proudly serving Canada from coast to coast.

#250589 05/01/05 03:42 PM
Joined: Nov 2004
Posts: 25
Member
Offline
Member
Joined: Nov 2004
Posts: 25
What type of computer is the MySQL database running on? Are you using any GUI to administer the database like phpMyAdmin or MySQL CC?

You can do this from a command line fairly simply. Navigate to the bin folder inside the MySQL installation directory and type in:

mysql -h hostname -u username -p password < path_to\my_sql_script.sql

This will feed the SQL script to the mysql client application and run it against the database specified in the script.

#250590 05/03/05 09:13 AM
Joined: Mar 2004
Posts: 188
chemcl Offline OP
Member
OP Offline
Member
Joined: Mar 2004
Posts: 188
Thanks for answering...I am just using the localhost. I can't even open mysql from the dos command prompt. I can open it from the actual sql on the start menu. I am not using a gui to interface right now. Got any ideas?? I have put the path in my computer to the mysql file and bin...c:\mysql\bin...I don't know what else to do. HELP!!


Cheryl McLean
Communications Done Right
#250591 05/04/05 04:02 AM
Joined: Nov 2004
Posts: 25
Member
Offline
Member
Joined: Nov 2004
Posts: 25
Try these instructions verbatim:

* Click Start, Run
* Type in cmd and click ok
* Type the following commands; each new line means press enter

cd \mysql\bin
mysql -h hostname -u username -p password < path_to\my_sql_script.sql

* Replace hostname with localhost and the username and password with the database credentials

The alternative is to download MySQLCC, which is a GUI front end for MySQL.

https://www.mysql.com/products/mysqlcc/

#250592 05/04/05 02:01 PM
Joined: Mar 2004
Posts: 188
chemcl Offline OP
Member
OP Offline
Member
Joined: Mar 2004
Posts: 188
If I type in the path that you gave, it gives me an error of "mysql is not recognized as an internal or external command, operable program, or batch file.

I have no problem using mysql, I just am having a problem being able to load a script and I think that it has to do with not being able to open it from the command line.


Cheryl McLean
Communications Done Right
#250593 05/05/05 08:44 AM
Joined: Nov 2004
Posts: 25
Member
Offline
Member
Joined: Nov 2004
Posts: 25
Unfortunately, 99% of the time, I'm running mysql from the command line via an SSH session, so I rarely run it on Windows. You might want to confirm that the mysql.exe executable exists.

Other than that, try out MySQLCC. It's a nice product.

#250594 05/05/05 01:09 PM
Joined: Mar 2004
Posts: 188
chemcl Offline OP
Member
OP Offline
Member
Joined: Mar 2004
Posts: 188
I am not finding the mysql.exe file. I find one that just has mysql but it opens up the window and beeps and then closes...so...

Also, if the .exe file isn't there then why am I able to open it up??

[This message has been edited by chemcl (edited May 05, 2005).]


Cheryl McLean
Communications Done Right

Moderated by  MooreTel 

Link Copied to Clipboard
Forum Statistics
Forums84
Topics94,262
Posts638,696
Members49,757
Most Online5,661
May 23rd, 2018
Popular Topics(Views)
211,098 Shoretel
187,707 CTX100 install
186,794 1a2 system
Newest Members
BPopilek, Rich F, LewisR, TDKs79, Buttinset
49,757 Registered Users
Top Posters(30 Days)
dexman 18
Toner 14
TDKs79 8
teleco 4
Who's Online Now
2 members (Toner, Touch Tone Tommy), 124 guests, and 241 robots.
Key: Admin, Global Mod, Mod
Contact Us | Sponsored by Atcom: One of the best VoIP Phone Canada Suppliers for your business telephone system!| Terms of Service

Sundance Communications is not affiliated with any of the above manufacturers. Sundance Phone System Forums - VOIP & Cloud Phone Help
©Copyright Sundance Communications 1998-2024
Powered by UBB.threads™ PHP Forum Software 7.7.5