Edit the script created by mysqldump. Add create database if not exists databaseName;
to the beginning of the script. Or what I usually do is create the database first then use: mysql -A databaseName < test.sql to load it. =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience -----Original Message----- From: Li Yang [mailto:[EMAIL PROTECTED] Sent: Sunday, March 30, 2003 8:10 PM To: mysql Subject: Hi,All ,About mysqldump and mysqlimport Hi, I'm a newbie to MySQL I have use mysqldump to backup a database to an file named test.sql ,but how I can load the test.sql to create the same database to another server?? Thanks! Best Regards Li Yang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
