9

I am using Ubuntu 14.04. I want to import my database which is located on the server /var/www/backup.zip. Also I've SSH access using Putty. Noted that MySQL and phpMyadmin are installed on the server.

When I run this command

mysql -u root -p spy < /var/www/backup.zip

nothing happens. A newline shows which starts with ->.

What should I do now?

enter image description here

18

I believe the format is:

mysql -u username -p database_name < /path/to/file.sql

From within mysql:

mysql> use db_name;
mysql> source backup-file.sql;
|improve this answer|||||
  • well what's the difference between yours (mysql -u username -p database_name < /path/to/file.sql) and mine (mysql -u root -p spy < /var/www/backup.zip)? – stack Aug 23 '17 at 6:04
  • 3
    @stack that George intends that command to be run in the shell, and not inside mysql. (That's why the rest of the answer is headed by "from within mysql".) – muru Aug 23 '17 at 6:08
  • @muru Ah I see. thank you guys. (btw I think you could say so 30min ago :)) – stack Aug 23 '17 at 6:11
  • in ubuntu you should add ./mysql to access file within xampp's bin folder otherwise it will search for global – Rj_Innocent_Coder Dec 5 '18 at 6:50
1

The main problem is that you're trying to run a bash command from within mysql. If you run that command at the regular terminal prompt the format of the command is correct.

The second issue is that you have a zip file and not a SQL file so you need to unzip it first.

How do I load a sql.gz file to my database? (on Server Fault) explains most of what you need. My answer there should work here too with a slight modification:

unzip -p /var/www/backup.zip | mysql -u root -p mydb

unzip -p unzips to a pipe, so that you can pipe that into your database command. Make sure the zip file only contains one sql file.

mysql -u root -p mydb is going to prompt you for a password (the -p without a value) and then attempt to pipe in the file data to mydb - change the mydb to your own database. You shouldn't specify the password in the command line as it then remains in your command history.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for?Browse other questions tagged or ask your own question.