export from online to local

[razstec]

Hi, i need some help creating a batch file that allows me to import a db from mysql online server to my local server in my computer.

Have tried some code that i google but i cant seem to work it out.

Code: Select all

mysqldump -u [root] -p [pobd] > [pobd.sql]  ----> export
mysql -u [root] -p [pobd] < [pobd.sql]  ----> import

Got this but how can i specifie that the export is from an online server and the import is to the local server?

Can anyone help?

thanks

[Squashman]

Could have sworn I saw this exact question asked on StackOverFlow the other day. I do not think we have too many MySQL experts here.

EDIT: Found it.
http://stackoverflow.com/questions/3328 ... with-batch

[razstec]

Yes your right.

I dont need the mysql, i need to know how to connect to server with batch file.

[Squashman]

Yes your right.

I dont need the mysql, i need to know how to connect to server with batch file.

No. You need to know how to connect to the server with the mysqldump command.
The link I gave you has another link that explains all that.
http://stackoverflow.com/questions/8444 ... mysql-dump

[razstec]

Cool, thanks