![]() This tutorial is in Ubuntu but will work on Redhat, Centos, Fedora, Suse. ![]() Then import it: mysql -u root -p lbry < dump-lbry.sql ![]() >mysql –u root –p database_name dump-lbry.sqlĬreate a database of the same name ("lbry" in this example) on the computer to which you wish to copy the database contents >cd program files/MySQL/MySQL Server5.1/bin “press enter” “press enter” Database name is must as that of your database_name.Ĭopy that sql file into location “c:/program files/MySQL/MySQL Server 5.1/bin” *- Now open command prompt and execute following commands.* Execute following command to create database. Open MySQL command line client command prompt. >mysqldump -u root -p database_name > database_name.sql “press enter”Ĭopy sql file and paste it in PC where you want to transfer database. >cd program files/MySQL/MySQL Server 5.1/ bin “press enter” We can use following method to transfer database.Ĭreating a dumpfile from database/ Taking backup of MySQL database:Įxecute following commands to change directory we cannot transfer itįrom one PC to another PC by copying and pasting it. ![]() MySQL database is not portable database i.e. We have to create dump file of database to transfer database from We can transfer a MySQL database from one PC to another PC using How to copy Mysql database from one Computer to another / backup database using mysqldump
0 Comments
Leave a Reply. |