You have hit a foreign key constraint error. You can try appending SET
FOREIGN_KEYS_CHECK = 0 at the beginning of your script and SET
FOREIGN_KEYS_CHECK = 1 and the end of your script to disable the foreign key
constraints.
-----Original Message-----
From: David Blomstrom
To: [EMAIL PROTECTED]
Sent: 6/3/04 2:44 PM
Subject: Can you rename or copy a database?
My database "world" won't work online, because the
online version is username_world, with a different
username and password. So I want to create a copy of
world named username_world.
I created a new database named username_world and
started importing tables into it, until I hit a
snag...
MySQL said:
#1005 - Can't create table '.\cdcol\counties2.frm'
(errno: 150)
* * * * * * * * * *
The quickest, easiest strategy would be to simply
create a copy of my database. But I don't see any
"copy" commands, unless you do it with the export
function.
If so, would simply save it as a SQL file alongside
your other databases?
SQL
LaTeX
CSV for Ms Excel data
CSV data
XML
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
