Form info to database on another server

Question

I have two websites; website1.com and website2.com. On website1 I have database with customer information and a neat CMS. Now I would like to make a registration form on website2 and insert that information in the database on website1.

Is this possible? Can I simply use mysql INSERT INTO~? Or do I need to use something else?

score 2 · Accepted Answer · answered Jul 16 '12 at 14:28

2

You can connect remotely to another server:

mysql -h host_name -D db_name -ppassword -c "insert into ..."

answered Jul 16 '12 at 14:28

Bohemian

412,405
93
575
722

score 0 · Answer 2 · edited May 23 '17 at 12:12

0

You need to allow MySQL remote connections if your websites are on different machines. Securing Remote MySQL

In both cases (remote or local), the method is the same: open a connection to website1's database and use INSERT INTO.

edited May 23 '17 at 12:12

Community

1
1

answered Jul 16 '12 at 14:28

Nikola K.

7,093
13
31
39

Form info to database on another server

2 Answers2