Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Closed Points: 125 Time: 08:46 - Jan 15, 2009
markclark
I'm trying to import a .sql backup of a database on my localhost with command line using: mysql> -uroot -p databasename < backup.sql hitting return I get -> and a flashing cursor but nothing seems to happen. could I be pointing to the .sql file incorrectly? Anything else I've missed?
Categories:
Add Categories
When adding more than one category, separate them with commas.
IronXavi
Date:: Mar 06, 2009
Time:: 07:13
It seems you are trying to run the "-uroot -p databasename < backup.sql" query while being logged into the mysql console. This has no sense. You have to call the following command from the DOS prompt (while being on the 'bin' directory of the MySQL installation, or from any other place if the 'bin' directory is in the system path): mysql -uroot -p databasename < backup.sql The program will ask you for a password (if root access is password-protected or not stored anywhere) then perform the import automatically. Hope this helps, IronXavi
Question Answered
This question has been closed, and points have been rewarded to the following experts:
You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial Area.
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
MySQL command line import of file with UTF-8 encoding.
You have 100 characters to use
Rank
Expert
Points
1.
10354
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software