Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

synchronize some Tables from Server A to Server B - Einige Tabellen von Server A auf Server B Synchronisieren

BoBBers's profile image BoBBers posted 6 years ago in General Permalink

English: Is it possible to Server A few tables highlight and that synchronize these matching with the labeled tables from server B?

I run an online store and would like to establish a database synchronization. There are mirrored all the information from the Store (Server A) on Xampp (Server B). Or just Syncs.

But maybe not all tables. There are tables containing e.g. Server paths or URL and they are different on Server A and B, of course.

German: Ist es möglich Auf Server A einige Tabellen zu markieren und dass diese mit den Markierten passenden Tabellen von Server B synchronisiert werden?

Ich betreibe einen OnlineShop und würde gerne eine Datenbank-synchronisation herstellen. Es sollen alle Daten vom Shop (Server A) auf Xampp (Server B) gespiegelt werden. Oder eben Syncronisiert.

Aber eben auch nicht alle Tabellen. Es gibt Tabellen, die enthalten z.B. Serverpfade bzw. die URL und diese sind auf Server A und B natürlich unterschiedlich.

ansgar's profile image ansgar posted 6 years ago Permalink

You can use the SQL export dialog, which can dump directly to another server, which just needs to be set up as a different HeidiSQL session. Select that session in the "Output:" dropdown, and then select the wanted data copy method in the "Data" dropdown. REPLACE or DELETE + INSERT may be the right method here.

See more details in the help section.

BoBBers's profile image BoBBers posted 6 years ago Permalink

Ohhh ooohhhhh, thats very awesome!

So i can Select only the tables i want to sync. and for that i use "Replace" / and can update the content, right?

Great :)

Feature request: That starts per button "Sync it" :D :)

Thank you

ansgar's profile image ansgar posted 6 years ago Permalink

Be warned: That is an export dialog, not a synchronize dialog. Replacing for example does not delete rows which are not present in the source table.

BoBBers's profile image BoBBers posted 6 years ago Permalink

yes i understand.

i take a full Backup from Server A to Server B over heidi SQL I create Tables and database but dont delete any database.

If it woks i set up a new Configuration on Server A and take a full Backup from Server B to Server A back

If that all works great i try to select only some tables from Server A to export these tables to localhost (XAMPP).

So i can use a local up to date Shop to test effective some features.

If it works great i can replace the table content from localhast on the apt (is that right for "matching"? or "suitable" :D ) tables from Server A.

BoBBers's profile image BoBBers posted 6 years ago Permalink

is it possible to save some "export configs" ?

So that i can use some export configs or load theese by click on the saved name from config export?

I mean that i can save some different configs with my own name like:

  • From Server B to Server A
  • From Server A to Localhost
  • From Server localhost to Server A
Fishbreath49's profile image Fishbreath49 posted 6 years ago Permalink

I really like this idea. I deal with a lot of servers that run different version of MySQL (typically older than my master DB) and I am, for various reasons, unable to upgrade so using Master/Slave setups isn't possible. Thus I often use HeidiSQL to export select tables to various other databases.

Being able to "setup" and save these export processes would be very handy.

ansgar's profile image ansgar posted 6 years ago Permalink

Well, HeidiSQL stores just the previous configuration, apart from the output option if it was a server, to avoid an unresponsive dialog when the previous server is unreachable.

BoBBers's profile image BoBBers posted 6 years ago Permalink

It where very nice if heidisql runs as a service in background to backup my database every 12 hours.

ansgar's profile image ansgar posted 6 years ago Permalink

Yes, but who needs that when you have mysqldump, which is even more powerful for backups?

BoBBers's profile image BoBBers posted 6 years ago Permalink

if you ask that, why you dont ask:why we need heidisql ? why we need windows or linux? why we need more different cars

But i think its better to run tasks with an windows clint as wich an server side application mysql dumt suspend support with php7 it dit not work

Fishbreath49's profile image Fishbreath49 posted 6 years ago Permalink

BoBBers, mysqldump isn't integrated with PHP at all.

You'd be better off writing a batch script to run mysqldump with a scheduled event. Bypassing PHP altogether. I use this extensively in my setup.

ansgar's profile image ansgar posted 6 years ago Permalink

HeidiSQL is not suitable at all for running as a service. It lacks numerous command line parameters for automating it, and it was always built for running with a GUI, in the foreground.

Using mysqldump will give you very powerful backup features, and it's lightning fast.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.