Dean,
Seems your database has a table with foreign key constraints. You need to delete
that table first and then you will be able to drop database successfully.
Hope that helps!!!
Raza
-Original Message-
From: Dean A. Hoover [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 4:13 A
Victor,
Will this not work for Innodb tables? If my backup also includes system
tablespaces and .ibd files ( we using multiple tablepsace), will that be a problem?
Thanks
Raza
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 9:03 AM
To
Egor,
If I write a script myself that backup .frm, .ibd and all log files, how good that
backup will be? Idea is not to shutdown the server though. Also I am using Innodb
tables, and mysqlhotcopy will not for Innodb. Innodb Hot backup tool works, but I
would prefer some free tool to do so.
W
Sanjay,
It seems you didn't run mysql_install_db script which is located in /scripts
directory. This script creates Grant tables for you when you first install mysql.
Basically the error says you missing those grant tables, you can re-run the script and
recreate them.
Hope that helps!!
Raza
I am trying to execute mysqld_multi script in unix. But it's giving me following error
"WARNING! my_print_defaults command not found. Please make sure you have this command
available and in your path. The command is available from the latest MySQL
distribution."
I have the laterst MySQL distrib
Does anyone know any FREE tool to migrate Oracle databases and schema to MySQL 5.0? I
know one such tool, "Oracle-to-mysql" which is not free though.
Thanks
Raza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT
Does anyone know if MySQL has the concept of Synonyms, as Oracle does?
Raza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In the MySQLdocumentation, it does not clearly explains how a Tablespace is
created. Under "Creating a Tablespace" heading ( 14.4.4), it says how a Innodb
database is created but not tablespace.
Also how exactly you create an Innodb Database. Well it says in the
documen