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

Restoring a db with RI enforced

2004-04-28 Thread Lou Olsten
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 trying to find an option for mysqldump, and the closes

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 --

Restoring a DB

2003-03-25 Thread Todd Cary
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"? Todd -- Ariste Software, Petaluma, CA 94952 \n [EMAIL PROTECTED]