New server from old server

Gps man2 years ago

I want to shift to new server keeping all data same excluding positions and events. Any script to do this transition smoothly

jay2 years ago

if you using mysql. do a backup, then copy it to new server and restore backup.

Gps man2 years ago

That is a difficult size when your DB is 1 TB on a cloud server. Need the sql scripts or import export data utility with list of tables to be checked

Anton Tananaev2 years ago

You can make a backup excluding some tables. For example:

mysqldump -u root -p traccar --ignore-table=traccar.tc_positions
Gps man2 years ago

Thanks for the response.

So I will add tc_events after comma

What steps to taken care of while restoring this dump in the new mysl server any specific precautions