Re: Restoring a db with RI enforced

2004-04-29 Thread Victoria Reznichenko
"Lou Olsten" <[EMAIL PROTECTED]> wrote: > If I'm using mysqldump to dump a database with referential integrity in place, does > MySQL > build the information in such a way that the referenced tables are loaded first to > avoid > invalid inserts into a table with a foreign key in place? I'm tryin

re: Restoring a DB

2003-03-26 Thread Egor Egorov
On Tuesday 25 March 2003 15:30, Todd Cary wrote: > If I have a file, mydb.mbk that was created with mysqldump, how do I > recreate/restore the DB? > > Do I run a command line using "mysql" with a switch and "mydb.mbk"? Yup. musql -uuser_name -puser_password database_name < mydb.mbk --