Hello,
I'm trying to make a daily database backup. When executing "mysqldump -
uxxx -pxxx database /home/backup/ddbb.sql -q &" the httpd server
gets blocked and my site is "offline" for 30 minutes. I also tried
using mysqlhotcopy, but with no success since it fails with error:
"DBD::mysql::db do failed: Not unique table/alias: 'comments' at /usr/
bin/mysqlhotcopy line 466."
I'd like to make a daily MySQL backup, but without freezing my httpd
server. Any ideas?
Thanks,
Antoni Massó Mola 6 6137
Antoni wrote:
Hello,
I'm trying to make a daily database backup. When executing "mysqldump -
uxxx -pxxx database /home/backup/ddbb.sql -q &" the httpd server
gets blocked and my site is "offline" for 30 minutes. I also tried
using mysqlhotcopy, but with no success since it fails with error:
"DBD::mysql::db do failed: Not unique table/alias: 'comments' at /usr/
bin/mysqlhotcopy line 466."
I'd like to make a daily MySQL backup, but without freezing my httpd
server. Any ideas?
Thanks,
Antoni Massó Mola
Are you perhaps using --locak-all-tables in the parameter list of the
mysqldump command ( http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html)?
To help us trouble shoot it would help if you would specify the command
line options you use and give us an estimate of the database and system
specs.
To prevent such problems I am not backing up my main server but use
replication to another server. To me it is no problem if the second
server to which the database is replicated is be offline for longer
periods, my main server should not, just like yours, more information
about replication can be gound in the MySQL manual: http://dev.mysql.com/doc/refman/5.1/en/replication.html
Jonathan
Hello Jonathan,
Im using MySQL 5.0.21-log in a Linux 2.4.33grs-bipiv-ipv4-32 #1 i686
Intel(R) Core(TM)2 CPU T5500 @ 1.66GHz GNU/Linux.
I did not include the --lock-all-tables parameter when running the
mysqldump command. May this parameter be assigned in another MySQL
configuration file?
The cron job executed every day is "mysqldump -uxxx -pxxx database /
home/backup/ddbb.sql -q &".
I'll use replication as soon as we get the money to purchase a second
server, but for now we need to stick with one server. The only two
possible ways I found for creating a database backup are mysqldump and
mysqlhotcopy. Is there any other way I can use?
Thanks!
Antoni
Jonathan ha escrit:
Antoni wrote:
Hello,
I'm trying to make a daily database backup. When executing "mysqldump -
uxxx -pxxx database /home/backup/ddbb.sql -q &" the httpd server
gets blocked and my site is "offline" for 30 minutes. I also tried
using mysqlhotcopy, but with no success since it fails with error:
"DBD::mysql::db do failed: Not unique table/alias: 'comments' at /usr/
bin/mysqlhotcopy line 466."
I'd like to make a daily MySQL backup, but without freezing my httpd
server. Any ideas?
Thanks,
Antoni Massó Mola
Are you perhaps using --locak-all-tables in the parameter list of the
mysqldump command (http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html)?
To help us trouble shoot it would help if you would specify the command
line options you use and give us an estimate of the database and system
specs.
To prevent such problems I am not backing up my main server but use
replication to another server. To me it is no problem if the second
server to which the database is replicated is be offline for longer
periods, my main server should not, just like yours, more information
about replication can be gound in the MySQL manual: http://dev.mysql.com/doc/refman/5.1/en/replication.html
Jonathan
>Im using MySQL 5.0.21-log in a Linux 2.4.33grs-bipiv-ipv4-32 #1 i686
>Intel(R) Core(TM)2 CPU T5500 @ 1.66GHz GNU/Linux.
I did not include the --lock-all-tables parameter when running the mysqldump command. May this parameter be assigned in another MySQL configuration file?
The cron job executed every day is "mysqldump -uxxx -pxxx database / home/backup/ddbb.sql -q &".
I'll use replication as soon as we get the money to purchase a second server, but for now we need to stick with one server. The only two possible ways I found for creating a database backup are mysqldump and mysqlhotcopy. Is there any other way I can use?
Replication. You can run multiple independent instances of MySQL
on the same server (but you need the CPU, memory, and disk resources
to do it) using independent port numbers, data directory locations,
socket, separate mysqld daemons, possibly separate UIDs, etc. You
distinguish which server to talk to by the port number or socket
location.
If load is an issue, it is possible to stop replication during the busy
period, then restart it during a lull, wait for replication to catch
up (SHOW SLAVE STATUS), stop replication again, and then mysqldump.
Thanks for your reply Gordon. Do you know of any tutorial that
explains how to achieve this?
Thanks again,
Antoni
Gordon Burditt ha escrit:
Im using MySQL 5.0.21-log in a Linux 2.4.33grs-bipiv-ipv4-32 #1 i686
Intel(R) Core(TM)2 CPU T5500 @ 1.66GHz GNU/Linux.
I did not include the --lock-all-tables parameter when running the
mysqldump command. May this parameter be assigned in another MySQL
configuration file?
The cron job executed every day is "mysqldump -uxxx -pxxx database /
home/backup/ddbb.sql -q &".
I'll use replication as soon as we get the money to purchase a second
server, but for now we need to stick with one server. The only two
possible ways I found for creating a database backup are mysqldump and
mysqlhotcopy. Is there any other way I can use?
Replication. You can run multiple independent instances of MySQL
on the same server (but you need the CPU, memory, and disk resources
to do it) using independent port numbers, data directory locations,
socket, separate mysqld daemons, possibly separate UIDs, etc. You
distinguish which server to talk to by the port number or socket
location.
If load is an issue, it is possible to stop replication during the busy
period, then restart it during a lull, wait for replication to catch
up (SHOW SLAVE STATUS), stop replication again, and then mysqldump.
Thanks for your help!
Antoni This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Terry A. Haimann |
last post by:
I have a databse with jpg in a blob field. I want to back it up with
mysqldump, but it appears to time out. Is there a way to limit the number
of records backed up (possibly with the where...
|
by: Adam Smith |
last post by:
Hope this is the right news group!!
I did a server upgrade and at the same time did a mysql update from
4.0.12 to Ver 12.22 Distrib 4.0.16
mach1# mysql --version
mysql Ver 12.22 Distrib...
|
by: Adam Smith |
last post by:
Hello,
I did a server upgrade and at the same time did a mysql update from
4.0.12 to Ver 12.22 Distrib 4.0.16. Essentially, moving from one machine
to another. The dump consists of a cluster of...
|
by: mcstayinskool |
last post by:
I'm trying to dump a bugzilla installation to a file, then restore it
to a different database name (so as to test my db backup system).
I use mysqldump to dump it to a file:
# mysqldump -u root...
|
by: Dave Crypto |
last post by:
Hi there,
SUMMARY:
1) When I use phpadmin to export a large database, the file created on
my local PC never containes all the tables and information. It seems
to max out at about 10mb.
2)...
|
by: Christopher Mouton |
last post by:
We regularly make drive images of our entire server and store it at a
backup site. To be honest I have never fully understood how the imaging
programs deal with open files. My question is will the...
|
by: Todd Cary |
last post by:
My client is using a shared server running MySQL 2.4, however the in
house server is 4.1.12 with mysqldump 10.9. Is there a way to have the
10.9 version output a format that is fully compatible...
|
by: Robert Blackwell |
last post by:
I want to make a scheduled task in windows to do a mysqldump. Someone gave
me this .bat to run but I'm not able to get it to work.
REM @echo off
for /f "tokens=1" %%i in ('date /t') do set...
|
by: lawrence k |
last post by:
I've installed Apache 1.3.36 on my Redhat EL 3 machine. Now I'm trying
to install PHP 5.1.4. I can not get the ./configure command to work. I
keep getting this error:
configure: error: Invalid...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |