windows to linux migration

[frenchpl]

Can someone assist me please.
I am trying to shift my mysql database from windows xp to centos 6.
On the windows I am running
mysql 5.0.83 and using administrator 1.2.17
However on the linux I am running
mysql 5.1.83 and trying to use workbench 6.3

I have backed up my database using the administrator
This created a windows Backup.sql file.

Trying to transfer this to linux and then restore it will not work.
The workbench just will not see the file even if I rename it.

My next trial was to open the backup file with Kwrite and then to copy
and paste the content directly into a mysql terminal.

This was successful on creating no only the database but all the tables.

However the data for the tables was a different story.

If there was a very limited number of rows of data it worked
Anything over 10 rows gives me a mysql syntax error.

Is there a way around this other than
trying to edit a file with thousands of rows of data.

I know there is a difference in the mysql proc table column numbers
from 16 in the older version to 20 in the newer but I
do not think that should make a difference here.
 

[kicken]

You can feed a .sql file as standard input to the mysql command line tool and it will execute all the statements.

 

mysql -u username -p < Backup.sql

[frenchpl]

Thank you Kicken that worked just fine

Now I have another configuration problem I have to solve.

My firefox will not connect to the mysql.

Reading the error logs I find that it is trying to connect via /var/lib/mysql/mysql.sock and cannot find it

The correct location is of course /var/lib/mysqld/mysql.sock

There is obviously a configuration file somewhere that is using the wrong info, however I cannot find it.

/etc/my.cnf is correct as is /etc/php.ini

I checked the /etc/httpd content and that seemed OK too.

Obviously I am missing one somewhere but where??