I need to move a MySQL database that is currently residing on a Linux server onto Windows server. The Linux server is running MySQL server version 3.23.49 and the OS is a flavour of Red Hat. The Windows server is Windows 2003 and is running version 5.0.45 of MySQL.
On the linux box I ran the following command :-
mysqldump -a -A -u root --password=manti156 www_website_apps_dev > apps_dev.sql
On the Windows box I ran the following command :-
mysql -u root --password=****** www_website_apps_dev < apps_dev.sql
which is giving the following error....
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root --password=****
www_website_apps_dev < apps_dev.sql
ERROR 1064 (42000) at line 9201: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to us
e near '-is_active-publication_date-start_date (id,is_active)
) TYPE=MyISAM' at line 23
Can anyone help ?
problems restoring a version 3.23.49 MYSQLDUMP from to version 5.0.45 MySQL server