Posted
by mouthpiec
on Server Fault
See other posts from Server Fault
or by mouthpiec
Published on 2010-03-31T22:44:15Z
Indexed on
2010/04/01
0:53 UTC
Read the original article
Hit count: 440
Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?
© Server Fault or respective owner
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
I tried everything till now:
sudo apt-get remove mysql-server mysql-client mysql-common
sudo apt-get purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
and even more commands...
But whenever I am trying to locate mysql. I get a no. of files related to mysql
command:
shell>>…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Mysql was started:
/usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
but when I'm trying to do something:
ERROR 1548 (HY000) at line 1: Cannot…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin.
As far as I can tell, the only copy of MySQL…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Can't start mysql with:
sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
120222 13:40:48 mysqld_safe Starting mysqld daemon with databases…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi
We are running backup exec 9.1 doing a backup to disk to portable hard disk drives.
When we run the backup manually it works fine.
But when the backup is setup to run in the evening on a schedule it does not run as the backup to disk folders goes offline and therefore has to be switched back…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I'm at a small company and we (the IT department of two) manage <100 client computers and a handful of servers. Currently we're using a company's appliance to handle backup; it does a small backup every night and a full backup every weekend, and a guy comes on Wednesday to take an offsite backup…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Recently we have moved some of servers from real servers- into virtual servers. Since then, we are getting errors like the following:
Error category : Resource ErrorsError : e000fed1 - A failure occurred querying the Writer status.
For additional information regarding this error refer…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
We're having quite some trouble at work using Windows Server Backup.
We have a HyperV server (Win 2008) running 8 virtual web servers, these are running a variety of OS'es: Win 2003, Win 2008 and a lone Debian.
Each virtual server has a separate partition on the physical HyperV server, so e.g. E:…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am backing up a Windows 2003 Small Business Server with SP2. We are running Backup Exec 12 with SP4. Recently the backup job started failing on backing up the system state with the following error:
V-79-57344-34110 - AOFO:
Initialization failure on:
"System?State". Advanced Open File
Option…
>>> More
