RE: can't drop database: ERROR 1217
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 AM To: [EMAIL PROTECTED] Subject: can't drop database: ERROR 1217 version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686) mysql DROP DATABASE xxx; ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails what is this all about? how the heck can I drop the database? Dean Hoover -- 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]
RE: restoring a database from tape
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: mt m Cc: [EMAIL PROTECTED] Subject: Re: restoring a database from tape If the table types are all MyISAM and you took a consistent backup the answer is most likely yes. Original Message On 3/15/04, 7:50:39 AM, mt m [EMAIL PROTECTED] wrote regarding restoring a database from tape: Hi, Recently we EOLed a machine that had a mysql instance. The /usr/local/mysql dir was backed up to tape before EOLing. Having now installed a new machine, we need to copy the old database from tape to the new machine. Mysql has been successfully installed on the new machine. To install the database, can I just copy the ../mysql/data directory from the tape to the corresponding dir on the new machine? thanks for your time. -M _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innodb Hot backup
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. Writing a script to backup .ibd and logfiles shouldn't be that bad, but just wanted to make sure if that will be an ideal backup as in online documentation it said this is the right way to do if you able to shut down the server. I know this question was asked numerous times in the list before, but i wasn't able to narrow it down to a single solution. If you know any other alternative please let me know. Thanks Raza -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 5:15 AM To: [EMAIL PROTECTED] Subject: Re: Where to find ibbackup Jonas Lind?n [EMAIL PROTECTED] wrote: Hello, I am runing mysql5.x and have just started fiddeling with how I should back up my innodb databases. I started reading about ibbackup and think it suits me. But the problem is I cant find it ;) Does ibbackup come with mysql or should I download it separatly from somewhere else? Anyone using it who could give me a hint? ibbackup is non-free software and it's not included in the MySQL distribution: http://innodb.com/order.php For backup of InnoDB tables you can also use mysqldump utility: http://www.mysql.com/doc/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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]
RE: urgent help required for mysql
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 GE Financial Assurance -Original Message- From: Soni, Sanjay K [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 6:48 PM To: [EMAIL PROTECTED] Subject: urgent help required for mysql 040225 13:57:20 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 040225 13:57:22 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 040225 13:57:22 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 040225 13:57:25 InnoDB: Started 040225 13:57:25 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040225 13:57:25 Aborting 040225 13:57:25 InnoDB: Starting shutdown... 040225 13:57:27 InnoDB: Shutdown completed -- 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]
mysqld_multi
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 distribution installed on my machine. If anyone seen this error before, please let me know the fix. Thanks Raza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
oracle to mysql
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 PROTECTED]
DOES MYSQL HAS CONCEPT OF SYNONYM
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]
Creating Innodb Database
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 documentation that when you enter the cmd mysqld it creates an Innodb Database, what if I want to have more than one Innodb Database within a server. Do I have to run multiple instances of mysqld. Can someone help here? Ansari,Raza GEFA GE Financial Assurance GE Insurance, Americas 6604 West Broad Street Richmond VA 23230-1702 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]