Is there is any dump command to export and import database from the remote server because i have tried this for local host database and this runs successfully but at the same time I run this command for remote server database it showing the error like " The system cannot find the file specified" The mysql command i used for exporting and importing localhost database is mysqldump -u root -p databasename > c:/html/databasename.sql The above command is executing successfully but for remote server database The command what i have used is mysqldump -p -h http://domainname.com databasename > databasename.sql It showing the error like "The system cannot find the file specified." Anybody help me to export and import database from the remoteserver ,using mysqldump command Thanks in advance
I never tried this scenario, but try the following mysqldump -uUSERNAME-HERE -p -h domainname.com databasename > databasename.sql Code (markup): Your mysql user must have rights to connect remotely and make sure your host allow remote connections.