TalkPHP - View Single Post

sketchMedia · 03-16-2009, 09:53 PM

like thus:

Code:

mysql -u user -p password -D database < backup.sql

Not sure if mysqldump dumps the db create statement, so you may need to create that first:

Code:

mysql -u user -p password

mysql> create database databasename;

then you can run source:

Code:

mysql> use databasename;
mysql> source backup.sql;

should do it.

03-16-2009, 09:53 PM	#9 (permalink)
sketchMedia The Prestige Join Date: Oct 2007 Location: Manchester, UK Posts: 854 Thanks: 32	like thus: Code: mysql -u user -p password -D database < backup.sql Not sure if mysqldump dumps the db create statement, so you may need to create that first: Code: mysql -u user -p password mysql> create database databasename; then you can run source: Code: mysql> use databasename; mysql> source backup.sql; should do it. __________________ mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0; Empty set (0.00 sec)