1

Setting automatic backups of MySQL database including table lock etc - MySQL Workbench?

view story
linux-howto

http://serverfault.com – We've got a Virtual Server with full ssh and root access running LAMP on Ubuntu Server. I've got a small computer in the office running ubuntu that isn't being used for anything. I thought I should use it to make and store (a copy of) our MySQL database backups. However, how do I go about backing up our databases? MySQL Workbench locks tables to avoid errors, amongst a host of other features, but does not have any planned automatic backup bits planned. MySQL Dumper doesn't specify that they can keep the database consistent. Source for information from this paragraph: I don't see the point o (HowTos)

grtyyu's picture
Submitted by grtyyu on 09/18/2012

Stories similar to Setting automatic backups of MySQL database including table lock etc - MySQL Workbench?

I've just installed MySQL workbench on my computer and have importend an old database into the system which seems to be working find. All the data is there and tables. I can do select, insert, updates etc.

However, if I expand a database, I see tables, views, routines. If I then right click on tables, nothing happens if I click create table...

Hi,

I'm looking for a bit of help creating an Ubuntu user account (not a MySQL user account) to remotely administer MySQL from MySQL Workbench.

Workbench uses SSH to initiate admin commands and the setup wizard specifies that:

This account needs write access to the my.cnf database config file, read access to the database logs and privileges to start/stop the database daemon.

I'm curren

I am getting dependency package errors as .

root@osscube:/home/abdul/Downloads# dpkg -i mysql-workbench-gpl-5.2.47-1ubu1004-amd64.deb Selecting previously unselected package mysql-workbench-gpl. (Reading database ...

I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key.

This MySQL Database Backup 1.2.1 is a free and open source software that will help us to automatically or manually backup the MySQL Database. I often confused on how to backup my existing MySQL database stored in my Windows XP box.

Normally when we create a backup of our MySQL using Mysqldump it creates a Read Lock on the database, so no changes can be made to the database at that time. It may take from a second to few minutes to take up backup of your database. So, sysadmin either prefer to stop MySQL or issue a READ lock on the MySQL table, so that database remains consistent.

A small database is easy to plan on paper, but the structure quickly becomes more complex as you add more elements. MySQL Workbench can help you keep the tables arranged.

MySQL Workbech Wont Connect 2 years 42 weeks ago

I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:

Quote:

Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens

MySql - mysql-workbench problem 2 years 42 weeks ago

Hi Guys,

I am looking to use the mysql tool mysql-workbench to administer mysql.

I downloaded the latest version from the MySql website, the fedora rpm. I used rpm2tgz to create a slackware package. Install seemed to go okay.

When I tried to run the mysql-workbench tool I got the following message.