Re: Need Restore Help

2006-07-27 Thread Jesse
I don't know why they renamed it again ?!? For better explanation and comparison take look here: http://www.mysql.com/network/compare.html http://www.mysql.com/products/database/ http://www.mysql.com/products Thank you. Those links were very helpful. I don't know why I can't seem to find anyt

Re: Need Restore Help

2006-07-27 Thread Remo Tex
Jesse wrote: Strange it ran just fine here on my 5.0.22-nt with sample MyISAM table `alumni`... Is your table `alumni` MyISAM or Innodb? It is MyISAM. Here are few more pointers: 1. If it is possible *always* try latest version first when solving problems. In your case 5.0.22 I think... Y

Re: Need Restore Help

2006-07-26 Thread Jesse
Strange it ran just fine here on my 5.0.22-nt with sample MyISAM table `alumni`... Is your table `alumni` MyISAM or Innodb? It is MyISAM. Here are few more pointers: 1. If it is possible *always* try latest version first when solving problems. In your case 5.0.22 I think... You were right.

Re: Need Restore Help

2006-07-26 Thread Dilipkumar
July 24, 2006 8:36 PM Subject: Need Restore Help I have a backup that was created by a MySQL 5 server using MySQLDump. When I try to restore the database using the following command: mysql -u root -p -D BPA < c:\backup\mydata.sql I get the error: ERROR 1064 (42000) at line 29765: You

Re: Need Restore Help

2006-07-25 Thread Remo Tex
Jesse wrote: Are you sure this is the right line - I mean the whole statement? You are right, I did not include the whole statement. Here's the entire section: /*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/; DELIMITER ;; /*!50003 SET SESSION SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENG

Re: Need Restore Help

2006-07-25 Thread Jesse
Are you sure this is the right line - I mean the whole statement? You are right, I did not include the whole statement. Here's the entire section: /*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/; DELIMITER ;; /*!50003 SET SESSION SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTI

Re: Need Restore Help

2006-07-25 Thread Remo Tex
Jesse wrote: I have a backup that was created by a MySQL 5 server using MySQLDump. When I try to restore the database using the following command: mysql -u root -p -D BPA < c:\backup\mydata.sql I get the error: ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax; check the

Need Restore Help

2006-07-24 Thread Jesse
I have a backup that was created by a MySQL 5 server using MySQLDump. When I try to restore the database using the following command: mysql -u root -p -D BPA < c:\backup\mydata.sql I get the error: ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax; check the manual that c