LinuxQuestions.org - how to automate replication within tables in phpMyAdmin?

- Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)

- - how to automate replication within tables in phpMyAdmin? (https://www.linuxquestions.org/questions/linux-general-1/how-to-automate-replication-within-tables-in-phpmyadmin-4175525588/)

cyberdome

11-16-2014 06:03 PM

how to automate replication within tables in phpMyAdmin?

how to automate replication within tables in phpMyAdmin?

I know how to replicate a table using phpMyAdmin, but how do I auto replicate a table using phpMyAdmin? for example, let us say I add 500 records/rows in table A, and it will automatically replicate those tables whitin the same database or different database, using phpMyAdmin. All database.tables will resided on the same server.

thanks in advance :)

Guttorm

11-17-2014 11:34 AM

Hi

Replication usually means hot backup to other servers. On one server, Are you looking for SQL views?

Code:

CREATE VIEW table_alias AS

SELECT * FROM some_table;

All times are GMT -5. The time now is 01:36 AM.