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
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..
I am attempting to write a backup script that will do the following:
1) lock and flush tables on a mysql db
2) dump the db to a file
3) unlock the tables
4) rsync the file to offsite storage
It all seems to be going well. However, obviously I don't want to setup ssh to the storage server on another network as the root user without a password. so I am attempting to su as the backup user inside of the script but when I try to run the script everything happens as it should until I try to so.. then it jumps out of the script .. akss me to login as the backup user.. proceeds to rsync to the offsite storage it does all this and then resumes execiting the script. it is not going to be setup as a cron job. it will be executed manually. assuming that is the case, how can I get the script to run without prompting for a password?
Here is what I've come up with so far... assuming that the script is run as root and the identity of the backup user will need to be assumed inside the script without perstering the user to enter the backup user's password.
[Code]....
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
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 Relatedi tried to install java jdk, and vlc, but to my surprise everytime i wanted to install a single application, a massive 500MB update appeared along with the 2 applications i wanted to install, then i tried the command line to just install one program, and got rep. errors, and several .lock errors at the command line. after hours of googling i gave up , this distro was recommended because of great laptop support, but it's a hell of trying to install a single program, with fedora i just did su -c 'yum install vim' , or ubuntu sudo apt-get install vim or slackware: installpkg vim.tgz , but opensuse was so bloated whenever i wanted to install a program or two. it is a royal pain to install anything in opensuse how do you guys deal with dependency hell in opensuse?
View 2 Replies View Relatedpolicy is to backup mysql with mysql-zrm.However at a certain stage it hangs forever. This is at the "flush logs". I tried this manually and it gave the same result. Even after restarting mysql and the host. After some googling and trying I found out "flush tables with read lock" gives the same result. The tables seem to be MyIsam. I tried with a mysqldump on one server and restore it on a test vm. I used the same config and flush logs still hangs. ALso I tried to change some configuration directives... but with the same result
Edit: btw, I checked the logfile and didn't found anything (/var/log/mysqld.log)
Edit2: I also did myisamchk -s *.MYI (in all direcoties with db files;actually did it with find command) and it did not return anything so datafiles seem ok.
How to configure IP tables in opensuse?My situation is,1. My network is connected in this way...ISP -> Hub -> Firewall Router -> Switches -> DNS ->LANI need to insert a linux system with iptables configured. I am expecting it that it should be between DNS and LAN. For that I am in search of "How to configure IP tables on opensuse10.3
View 2 Replies View RelatedI've been successfully dualbooting OS-X and various debian based linux distros for a while now on my macbook pro. I use rEFIt. gptsync gives me the following error message:
[Code]...
Status: Analysis inconclusive, will not touch this disk. Is there any way to force the partition tables to sync? Currently, I have to use the OpenSUSE live DVD to boot into my OpenSUSE install.
Is there a terminal command to lock the screen? I am using GNOME if that matters
View 3 Replies View RelatedSo I have a script that runs from 'Startup Applications'. That works fine. However, I also want it to run after I unlock a locked screen such as after suspend or a screensaver. I have mod3+t as a shortcut to it, but it would be nice if I could get it to run automatically.
View 2 Replies View Relatedis there a way to deactivate Caps Lock via command line? I mean: no matter whether Caps Lock is either active or not, issuing such a command would deactivate it. I'm not talking about disabling the key.
View 2 Replies View RelatedI just upgraded to Natty on my Dell 10mini. It runs great but I was wondering what the command-line input for locking the screen. I'm trying to bind a command to a key that will lock my screen and suspend my session all at once, but all I can find is the command for suspend. gnome-screensaver-command --lock doesnt seem to work on unity (obviously). Is there a variation of it that I can use?
View 2 Replies View RelatedWhen I shutdown my server it seems to lock up. I use ssh for a headless unit and I can reboot fine, but I told it to shutdown and disconnected me and stopped logging (as far as I can tell) and then nothing. The lights stayed on and I had to press the power button. Is there a way to keep the logger running or to look someplace other then messages. I'm not great with logs.
View 8 Replies View RelatedHow can i enable caps lock by using echo command. I know that by using syntax echo -e "33[3q" this only turns the capslock led to glow. but the capslock is not working i.e. the words are typed in small case only.
Then by using xmodmap command i.e. syntax xmodmap -e "remove lock = Caps_Lock" or xmodmap -e "add lock =Caps_Lock" doesn't work. On running this it shows unable to display.
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 RelatedI have a pc trying to install fedora. It is an amd downloaded and tried to install different versions of fedora. The latest i686 and will get to a boot screen and when selecting boot will lock up at the i386 start kernal command and blinky curser. Yes I am new to linux and may need some hand holding. I have however successfully installed fedora on other computers a while back which is why I am not sure what is going on. It may be a hardware mismatch. I will try to see if I can find another computer to install. I used a different computer and is working. The athlon computer is not working.
View 5 Replies View RelatedI 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?
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 RelatedI 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.
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 View RelatedI just downloaded OpenOffice 3.2.1 from the openoffice.org weebsite. I followed the instructions precisely and everytime ended up in the same error message - 'error: can't create transaction lock on /var/lib/rpm/.rpm.lock (Permission denied)'. I am using Fedora 13.
View 2 Replies View RelatedWhen i connect windows server 2003 from ubuntu these error displayed .When i installing the tsclient, by executing these following command from a Terminal window:
sudo apt-get install tsclient
When i run these command the following error displayed.
E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
I have a HP Pavilion dv4 that is 4 months old. Yesterday it suddenly seemed to restart then once I logged in it turned off. When I tried to turn it on some of the lights came on and the caps lock and num lock started flashing. Since then I have not been able to get it to work correctly.It once seemed to turn on but died again after the login window.I tried to use my live cd but the same thing happened. It started loading once, but then shut down again. Every other time it stayed dead minus the lights
View 1 Replies View RelatedI recently installed Ubuntu 11.04 on an old Sony Vaio laptop. I was following some of the steps here..[url]
The step "Enable Full DVD Playback(Dual Layer DVD Support)" did not finish correctly doh and now I can't use 'sudo apt-get' for anything or the software center or using the 'Update Manager' does not work.
The update manger says it may be caused by an update not finishing correctly which sounds correct as explained above. The apt-get command gives me back the following....'Could not get lock /var/lib/dpkg/lock resource temporarily unavailable' 'unable to lock administration directory /var/lib/dpkg is another process using it?'
I tried the obvious restart but that hasn't worked.
my problem is the terminal:
E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied)
E: Unable to lock the administration directory (/var/lib/dpkg/) , are you root?
I have pidgin2.5.2. I want to install pidgin2.6.6.How can I do that?E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
View 1 Replies View RelatedThere is a very strange problem I've been having. When I enable either Caps Lock or Num Lock the media controls on my keyboard cease to work. I have Googled this one to death but found nothing. This problem existed in Xubuntu 9.10 and now still exists in Xubuntu 10.04. The keyboard I use is a Logitech Elite Keyboard. I would love to be able to use the Caps Lock and Num Lock without the worry that I am disabling the media controls
View 4 Replies View RelatedI have just burned the latest CD using infraRecorder, as per the instructions on this site, however when I boot from this CD, it spends about 5 minutes moving the red balls across my screen, then all of the sudden it just freezes, and my caps and scroll lock lights start to blink. I've had a look in the forums already but there's nothing about this happening on Boot of the live CD.
View 6 Replies View RelatedI'm wondering why the num lock doesn't work in Ubuntu anymore? When you press the "num lock" key, you're supposed to be able to input the numbers along with + - * / and decimal point. When I press num lock and try typing numbers, nothing happens.
I've done a google search and this is a well known problem that nobody has fixed. In Windows it's never a problem.
Seems such a shame that the great Ubuntu and Linux are so good for stability and speed, but can't get a simple num lock working.