CODEWITHSUNDEEP
mysqlmysql-workbench
Ben Barter
Ben Barter

Reputation: 159

Will exporting a database using MySQL Workbench cause downtime on server?

I am using Workbench to export a database stored on my hoting providers server, will the server experience any downtime whilst I am exporting the data?

The only reason I ask is because when I back up my local SQL database my server needs to be switched offline for it to work.

All comments will be much appreciated.

Ben

Upvotes: 1

Views: 487

Answers (1)

Mchl
Mchl

Reputation: 62395

No it will not cause a downtime, unless your server has really low resources (in which case you should find a better hosting). Seriously though, nothing bad will happen.

Also I can hardly imagine why you need to disable your localhost for backup... Workbench uses mysqldump for exports and this in turn needs MySQL to be online...

Upvotes: 4

Related Questions