How to transfer MySQL database from Windows to Ubuntu?

Question

I want to transfer my database from WAMP on my local machine to my Ubuntu VPS.

Can I just copy the folder of the database from C:\wamp\bin\mysql\mysql5.6.12\data to /var/lib/mysql?

Solution

mysqldump is the general method to copy a database over.

Create a dump on windows:

mysqldump -u [USER] -p [DATABASE] > [BACKUP]

Copy the file over to Ubuntu and restore it in Ubuntu:

mysql -u [USER] -p [DATABASE] <./[BACKUP]

• both commands are done from the shell (not from within MySQL).

Comments

[Rinzwind]

Ehm I would dump the databases and load them.

[MahmoudSenSei]

thx but i have this error "mysqldump is not recognized as an internal or external command"

[NGRhodes]

You need to change directory to where you run mysql from.

[Rinzwind]

@MahmoudSenSei sorry I am not a windows user. you are on your own ;)

[MahmoudSenSei]

Thx i just found the solution, i searched for mysqldump in Wamp and copied it in c:\windows\system32

[MahmoudSenSei]

@Rinzwind last thing , should i create an ampty database in the server to dump in it my new database ?

[Rinzwind]

Yes. A dump does not make the db itself (you also need permissions to it ;) )

[MahmoudSenSei]

@Rinzwind permissions ?

[MahmoudSenSei]

u mean the user should have all privileges ?

[Rinzwind]

permissions as in GRANT PRIVILEGES etc.

[Sanal S]

what if mysql crashed and won't start on windows. how can i transfer database from windows to ubuntu in such case?