Page 1 of 1
MYSQLDUMP
Posted: Sat Jul 14, 2007 5:48 pm
by pinehead18
I have a backup from another server with all the tables etc for a db.
I created the db pinehead
and i want to take this text file and dump it so it creates all the tables etc inside of pinehead
I'm using mysql_dump -upinehead -p pinehead dump.db
But it doesn't work.
Suggestions?
Thanks guys
Re: MYSQLDUMP
Posted: Sat Jul 14, 2007 5:56 pm
by volka
pinehead18 wrote:But it doesn't work.
Do you get something like an error message? Anything?
"it doesn't work." usually isn't the "whole story"

Posted: Sat Jul 14, 2007 6:18 pm
by pinehead18
I don't think the sytax is right cause it says dump.db not correct table name.
Is it the right syntax?
Posted: Sun Jul 15, 2007 6:46 am
by superdezign
pinehead18 wrote:I don't think the sytax is right cause it says dump.db not correct table name.
Is it the right syntax?
Have you looked online to see if it's the right syntax? There's bound to be quite a few self-proclaimed experts with it on their websites.
Posted: Sun Jul 15, 2007 7:33 am
by facets
I use the following to import into my db.
mysql -u'name' -p database_to_recover < database_backup.sql (this will prompt for a password) (-p'password' should work too)
I assume the database names are the same?
will.