Take data from database 1 and pass to database 2

Asked

Viewed 49 times

0

I have a database on a host and wanted to pass data to the database of another host, but the host does not accept external connection, how can I do this? Would anyone have any suggestions? using PHP and MYSQL

php

  • Makes php and runs inside the server, uses PDO makes two connections from select captures the values and gives the Insert in the other database

  • 1

    The simplest way is to log into the server by a phpMyAdmin, export to one and import to the other

1 answer

0


If you have access to Phpmyadmin it is easier simply to export and then import to the new destination.

If you only have access to the command line you can use mysqldump something like: Exporting:

mysqldump -u root-p database1 > database1.sql

Importing:

mysql -u root-p database2 < database1.sql

Remember to change the data for connection

source: Here

Browser other questions tagged php

You are not signed in. Login or sign up in order to post.