Server :: Locks Table During Mysqldump?
Dec 7, 2010
We are running an adserver with mysql as the database. We backup the database every hour and lately noticed that ads doesn't get delivered at the time of backup. The database size is 1.2 GB in which a single table ifself is 1.1 GB. Googling around the problem says this may be due to lock table feature in mysqldump and disabling it might solve the issue but i'm afraid whether this would be a problem. Can anyone please explain what lock table means and will it be a problem if i disable it or may be any other alternative solutions/assitance (other than master/slave or replication since we cannot afford it at this time) would be really helpful.
View 1 Replies
ADVERTISEMENT
Jan 20, 2011
I have one doubt, is copying /var/lib/mysql is a good alterntive to mysqldump?.
Because i use rsync to copy /var/lib/mysql for back up without dumping the database. I use rsync to do differential backup up so that it copies /var/lib/mysql to /var/tmp every one minute.
View 14 Replies
View Related
Feb 18, 2011
I have some tables that contain special characters from different languages like German, Italian, Russian, Spanish etc. They are stored and displayed correctly.
When want to backup my DB like "mysqldump -h localhost-u root -p dbname > dbname.sql" the special characters are lost, they are not correctly stored nor displayed in the sql file. This means there is no possible restoration.
View 3 Replies
View Related
Jan 2, 2011
I noticed in phpmyadmin that we can export a database in type update. Indeed we have update... in place of insert.... is there anyone know if it possible by a command line or by a simple PHP code ?
View 1 Replies
View Related
Jun 2, 2010
Dear Experts,
I am having a 1 gb of mysqldump. When i try to restore this dump file, it is giving error " ERROR 1153 (08S01) at line 289: Got a packet bigger than 'max_allowed_packet' bytes". And with this i am not able to restore the database. mysqld version is 5.0.77.
View 4 Replies
View Related
Aug 20, 2010
I've had an interesting experience that is completely unprecedented in my history of using rsync. As I write this I'm listening to my server squeal like a stuck pig as the Adaptec RAID controller rebuilds my RAID-5 array (and doesn't lose any data, I HOPE!!!!) rsync is an integral part of my Disaster Recovery plan at the office. I have a NFS server that hosts all the business critical VMs that my company runs and a couple of VMware hosts that link thereto and attempt to make the best of things. I know NFS isn't the most optimal solution, but that's a conversation for another thread.
My rsync woes began tonight and took an unexpected turn for the worst as I was attempting to implement the most white-knuckled portion of this scenario.The Process:
1. A script runs that shuts down all VMs that access the NFS array
2. Post-shutdown, the server then rsyncs to a local HDD for fast-backup and to minimize downtime
3. During daily operation, another script will rsync the backed-up VMs to an offsite server that keeps them in case we have a disaster scenario
My plans never made it to step 3 since rsync started crashing during the local portion (step 2).My Hardware:
1. Adapted 5405 4-port hardware RAID controller
2. 3 x Western Digital Black SATA 2.0 HDDs (1TB each) in RAID-5 config
3. 1 x Western Digital Black SATA 2.0 HDD (2TB) in solo-mode on the same controller
View 4 Replies
View Related
Mar 17, 2010
Last night at 1:47 AM yum installed the current version of kernel-headers on my RHEL5 server:
Mar 17 01:47:47 linux1 yum: Updated: kernel-headers-2.6.18-164.15.1.el5.i386
Mar 17 13:47:22 linux1 syslogd 1.4.1: restart.
This locked the server up until I could physically get to it this afternoon and reboot the server. I then finished downloading and installing the new kernel, rebooted again, and the server appears to be running fine.
This is the second time this has happened on this server.
Has anyone else seen this problem when you setup yum to automatically update your servers? Other than manually updating servers, does anyone have any suggestions on how to keep this problem from happening again?
View 2 Replies
View Related
Oct 23, 2010
i need to prepare a presentation for that i have to copy a table from [URL] to my power point slide. but when i am copying it i am just getting a table with single column. is there a method to import the contents from web page table to my presentation table?
View 2 Replies
View Related
May 3, 2010
Kmail 1.13.2 Problem on startup, error is from nepomuk, data storage. "cannot find Redland backend, nepomuk is disabled until fixed. Also see the following error from the akonadi console:
100503 10:00:15 [Note] Plugin 'ndbcluster' is disabled.
100503 10:00:15 InnoDB: Started; log sequence number 0 31413862
100503 10:00:15 [Warning] Can't open and lock time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without
[code]....
View 2 Replies
View Related
Aug 2, 2010
I have a LAMP website with mysql backend with InnoDb engine for tables.I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. shutting down the website) for the duration of the backup. not even in the mySQL documentation. A lot of mention is made about mysqlhotcopy, but that only works for IMSAM tables - and is therefore of no interest/use to me.Does anyone know if (how?) I can use mysqldump to take a copy/dump of a database that is still being used?.A link to the official documentation would be very useful, since I want to make sure that I get this absolutely right.I am running on Ubuntu 10.0.4 LTS
View 4 Replies
View Related
Oct 31, 2010
So basically what I am trying to do is install Ubuntu 10.04 on a Dell Poweredge 2600 server. Right now I dont care wither I get the server version or the desktop version, I just need to get it on their. this is what I have run into. When installing the regular Ubuntu 10.04 desktop for 32bit, the server just locks up on the very first ubuntu install screen and the keyboard lights just start blinking non stop. When I use the server version, the server get to the Detecting Network Hardware and locks up at 94% and the keyboard will also start blinking nonstop. I have looked all over for an answer to this problem and have yet to find one. This guy figured out how to make it work but he never mentioned what version he was using. [URL]..
On this server I have 6 HDs, 5 of them are RAID 0 with 1 Hot Spare. I have also tried using the ubuntu-10.04.1-alternate-i386.iso.torrent and still had the same problem. I have spent the last 3 days searching all over google and the forum to an answer but had no luck.
View 9 Replies
View Related
Jul 13, 2010
I would like to have my backup script that I am writing to create a sql dump of my database and go directly into a tar file. Does anyone know how I could do this with one command?
To be more clear I would like to go from
mysqldump -u xxxx -pXXXXX tablename> currentbackup.sql
tar -czvf backup-XXXXXXXX.tgz currentbackup.sql
rm currentbackup.sql
To a single command somehow. Does anyone know how I could accomplish something like this?
View 2 Replies
View Related
Feb 4, 2010
Is it possible to compress the mysqldump output into say db_backup.sql.tgz. Then add that to an existing archive e.g. backup.tgz in one command or on the fly to save space and deleting it?
View 3 Replies
View Related
Feb 25, 2011
what is the translation table and referance table in any DB (with referance to Data conversion)
View 2 Replies
View Related
Sep 20, 2010
When I execute the command below, does mysqldump lock all tables while the backup is in process? I want to make sure this is the appropriate type of backup command for MyISAM database.
mysqldump -h myhostname --default-character-set=utf8 -u root --password=mypassword --opt --single-transaction DBname > /root/backup.sql
View 2 Replies
View Related
Jul 20, 2010
i use linux ubuntu..i try to copy db and type some mysqldump command..but at terminal show: The program 'mysqldump' can be found in the following packages:
* mysql-client-5.0
* mysql-client-5.1
Try: sudo apt-get install <selected package> bash: mysqldump: command not found
how to get mysqldump for my pc? i've tried to follow the instruction,but show like below:
Err http://ubuntu-ashisuto.ubuntulinux.jp jaunty/main libnet-daemon-perl 0.43-1 Could not connect to ubuntu-ashisuto.ubuntulinux.jp:80 (122.216.218.146), connection timed out
View 3 Replies
View Related
Apr 22, 2011
I've this script which takes backup of mysqldb through mysqldump. I need to send an automated email after success/failure mysqldump. How can add this feature in the script? Here's the script:
Code:
#!/bin/sh
BACKUP=/data/backup/sql2/new_backup/daily
cd $BACKUP
mkdir `date '+%d-%m-%Y'`
NOW=$(date +"%d-%m-%Y")
code....
View 3 Replies
View Related
Aug 7, 2009
I have 2 servers, 1 running a web server on 1 IP address,the other server running a proxy on a different IP address. I intend to change and update the ncsa file with usernames and passwords from a mysql table.Is there a way to replicate 1 table from the webserver to the proxy server databases and then run a cronjob? The cron will simply delete unused usernames and add new ones.Is there a better way of doing this? I don't want to run the webserver on the proxy server for security and also for performance.
View 2 Replies
View Related
Nov 18, 2010
Let's say we have a file tables listing all the tables of a database.Can I use grep and mysqldump to dump only tables with certain prefix? I tried
grep prefix_ tables | mysqldump -u root -p databasename > db.sql
but this takes all the tables..
View 1 Replies
View Related
Apr 14, 2010
My cron job is executing the below mysqldump command but it produces an empty sql file. However, when I run from the command line, it works as expected.
Code:
15 6 * * * root mysqldump -uroot -pXXXXXXX mydbname | gzip > /home/dbbackup/db_`/bin/date +\%Y\%m\%d\%H\%M`.sql.gz
I'm on CentOS 5.4 and use "env EDITOR=nano crontab -e" edit my cron (then paste the above command.
View 5 Replies
View Related
Dec 10, 2010
For some reason I am unable to view my database tables for my Wiki & I can't understand what I am doing wrong or what I'm missing. I know for sure there's table data on my 'wiki' database but for some reason I don't know how to list it.
Code:
psql (8.4.5)
Type "help" for help.
[code]....
View 1 Replies
View Related
Feb 14, 2011
What does mangle table means in iptabels? Please express it easily so that I could easily understand it.
View 1 Replies
View Related
Apr 9, 2011
I had to rename a table yesterday due to a contact / group name change in the office and sadly I'm the only person who knows how to barely interact with SQL due to my years as a Linux Administrator. Renaming the table was simple:
Code:
iamunix=# ALTER TABLE accounts RENAME TO marketing;
ALTER TABLE
[code]....
View 2 Replies
View Related
Jul 6, 2009
When a user logs into my webmail application, it creates entries in a table on MySQL called "identities" which works great however once the user is deleted fro Linux with the "userdel -r" command, the data still sits in MySQL. My question is how I can I remove the table data from old users? It appears as show below:
[code].....
View 1 Replies
View Related
Jan 14, 2010
I just backup my mysql db using mysqldump. I run it around 6pm of the evening but I just notice that on the last part of the dump file, it says "Dump completed on 2010-01-14 11:30:01". The time is "Jan 14 19:30" when I run mysqldump. Though the content is corrent, I still want to know why the dump reported it was completed but wrong time. I don't have my.cnf on my /etc so it means all was default by mysql. If I'm not mistaken, timezone by default in mysql is gmt.
My /etc/sysconfig/clock is
ZONE="Asia/Manila"
UTC=true
ARC=false
When I do "select now();" on mysql shell, it was the same with my system. I want to prove my backup was right but this thing confuse me a bit.
View 1 Replies
View Related
Aug 19, 2011
We purchased a virtual server from GoDaddy (1 month trial) to set up as a proxy for our networks (24 of them). I am having 2 separate issues. The first is I can't configure/install NAT and support is telling me the only way I can is to purchase a dedicated server. Here's the error:
iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-port 3128 iptables v1.3.5: can't initialize iptables table `nat': Table does not exist (do you need to insmod?) Perhaps iptables or your kernel needs to be upgraded. Here's the fix: [URL] So, what I am hoping to do is configure this by just opening port 3128 directly, and only allowing access from our networks. As a test I did this and allowed only from our office and it did not work. However I can't connect, so I am wondering what I am doing wrong? Here's my squid configuration:
[Code]....
View 4 Replies
View Related
Jun 15, 2010
How to configure proxy server with SQL table user authenticationon fedora core11
View 1 Replies
View Related
Sep 2, 2010
my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies
View Related
Nov 11, 2010
I had a RAID controller in a system that would not load Virtuozzo. So I deleted the array created by the 3Ware 9550SX controller before removing it and one drive from the CentOS 4.8 server. Even though I deleted the array when the server boots it shows an error:
ERROR : asr : invalid RAID config table
How can I clear and remove the table without having to reload the OS? Can I? Di I need to run the Seagate Tools and reset the drive?
View 1 Replies
View Related
Jan 26, 2011
We have a MyISAM table without .MYD and .MYI files for storing data and index but we can select data from the table. We can't use mysqlhotcopy for backup the table. Each time,we execute mysqlhotcopy, we have the following error: 'dbs.table: is not base table'. How do we repair the table to re-create .MYD and .MYI files?
View 2 Replies
View Related
