General :: How To Use The Mysqldump
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
ADVERTISEMENT
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
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
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
Jan 22, 2010
if I run mysqldump from crontab and error occurs, I would like to have email send to me (reporting that backup is not working).
View 2 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
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
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
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
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
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 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
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
Oct 12, 2010
My Ubuntu system is occasionally becoming very sluggish. I'm running many things simultaneously and it's very difficult to tell which program is the culprit.
I suspect that the sluggishness is due to disk activity since the CPU usage is consistently under 50% on each of the 4 cores of the CPU, and over 30% of the 6GB of RAM are free.
Is there a tool that can show me in real time the number of disk IO operations per second and the amount of data read/written per second? Can all this info be broken down and displayed per process?
View 2 Replies
View Related
Mar 3, 2010
I want to write a shell script, so that at 9AM every morning a general will be sent automatically to my network users E-Mail ID. My users are as follows: akhtaruzzaman@a[URL], ariful.[URL] etc.
Below is my little effort:
# !/bin/bash
userlist=`cut -f 1 -d : /etc/passwd`
mail -s "mailbackup" << END
keep mailbackup in another drive daily for security purpose
View 3 Replies
View Related
Nov 4, 2009
I'm using my Linux (SLES 10) server as a File Server at this point. I need to set File Permissions to nested folders differently to different groups. For example:
homesharedengineering* should be read only for groupA
homesharedengineeringadmin should be read & write for groupB Plus read only for groupA
homesharedengineeringautocad should be read & write for groupC Plus read only for groupA
I've been using Webmin and Putty to set permissions but Putty only allows me the Default Group, it won't allow me to set several groups on the same directory. Webmin seems to allow me to add multiple groups (Webmin --> Others --> File Manager --> Info & ACL tab will provide extended abilities) but when I add multiple groups, they don't seem to take effect? I'm wondering if my setup at the 'Share' level or at the hierarchy of my folder structure (unix based) needs to be set specifically?
View 1 Replies
View Related
Jun 18, 2011
I have Windows 7 on my Dell Xps laptop, and I want to install Ubuntu or Fedora as a dual-boot. Will that cause my system to slow down?
View 2 Replies
View Related
Jan 29, 2011
PackageKit is a system designed to make installing and updating software on your computer easier. The primary design goal is to unify all the software graphical tools used in different distributions, and use some of the latest technology like PolicyKit to make the process suck less.
View 1 Replies
View Related
Jun 6, 2011
II'm a front-end web developer, I've always developed on Windows with technologies like XHTML, CSS, Javascript and Flash, I've dabbled with PHP and MySQL. I am well used to Windows workflows and tools, from Photoshop to Notepad++, Filezilla and WAMP server stacks to After Effects, and a swathe more - but always on Windows.I'm at a point where I think I need to start seriously developing on a Linux box, specifically at the moment to create web apps based on Node.js, but compiling tools and programs has become a task I'm more frequently required to do.
My question? I need to get my hands on a user-friendly install of Linux, but which one? I need common interface developer tools (lists welcome) to replace... well as many tools I have on Windows as possible.I need to be readily connected to the internet, I need OS updates to not destroy my workflow by crashing the OS, as I've seen Ubuntu do to various friends. I want efficiency, I need to be able to customise what I need to in order to perform development tasks.I guess this could be a long list, but - I don't have practical working knowledge of the Linux OS, nor how it "compares" to Windows (excuse my faux pas). I'm obviously willing to learn, but I'm far, far more keen to just... continue interface development, just on Linux instead of Windows.
View 3 Replies
View Related
Jun 27, 2010
A friend of mine helped me set up a server which includes Squirrel Mail.It?s CentOS 5.3.I have a person who would like to access Squirrel Mail at remote sites.My questions is, I can create an account on the server which has KDE and the usual general applications and he would have the remote access Squirrel Mail but he doesn?t need nor does he want to access KDE or anything else on my server. He just want an account so he can use Squirrel Mail.
View 1 Replies
View Related
Mar 23, 2010
I have the impression that not that many people understand the scope and limitations of GNU General Public License. This is somehow my basic understanding of it. If I take a program covered under the GNU license, first of all I have the right to get the source code. Second, I can modify it at will. Third, I can redistribute it as will too but the new code will necessarily will have the same GNU license. This made me wonder how people actually can charge for software derived from Linux, for instance, Red Hat. Well, my impression is that they really make profit only out of services. In this thread [URL] I think I found a lot of confusion, even from a moderator (not intended to offend). Red Hat is based on Linux and it is necessarily covered under GNU. Somebody probably bought the program from RHE and can make it available at no cost.
Nevertheless, the moderator decided to warn the user. In this article [URL] it says the following:"Our training is not designed to promote vendor lock-in. Though these courses are based on Red Hat Enterprise Linux, the source code for [RHEL] is available to the community via the GPL [GNU General Public License]," said Red Hat spokewoman Leigh Day. This thread [URL] shows yet more confused people. Is there is a glitch in this type of license that prevents programs like RHEL to be redistributed for free? Why their license page doesn't mention GNU license? Or the problem is just that people get overwhelmed by this license and are afraid to be penalized and get paralyzed? By the way, RHEL is just the example. The key question is about the license!!
View 14 Replies
View Related
Sep 9, 2010
I need to allow certain users (who do not have root access) to be able to stop and start specific daemons
View 2 Replies
View Related
Jul 16, 2010
What is the general opinion of the Mandriva and Debian distros? Mainly asking what kind of user you consider the distro to be for (beginners, advanced, total newb, whatever), and whether you think they offer as much to an extremely experienced user as they would to a newb.Those are my two favorite distros, and I really like Mandriva a lot. I'm trying to pick one to stick with throughout, but I'm not really sure if Mandriva is too automated and Windows-user oriented like Ubuntu (I haven't really delved into the deeper aspects of Linux so I have zero experience in this area now). This might sound a little elitist but I don't want to be using Mandriva and just be automatically dismissed as a newb on first impression just because I'm using Mandriva (although admittedly I am a bit of a newb at the moment, I don't plan on staying one).
View 4 Replies
View Related
Apr 3, 2010
Im trying to get a general understanding put simply.
View 6 Replies
View Related
Jan 9, 2011
Friends i am facing some issue with Linux i want to know how many kinds of file do we have in Linux and what are soft link and hard link mean and the difference. However i want to know also why do we use it in Linux
View 1 Replies
View Related
Mar 27, 2010
I have a computer on LAN running ssh. I can normally tunnel the GUI application usingssh computer-name -X program-nameBut I wam my full desktop to be running on a remote computer using ssh so that I can just use that computer remotely like a local desktop. For this I think I will need to run KDM (or GDM ) remotely, what configuration do I need to do to make this happen?
View 2 Replies
View Related
Jun 15, 2010
I'm wonder what the differences are, especially as it pertains to SharePoint. Why should I pick one over the other or does it matter? Also are there any Linux browser solutions for SharePoint, besides Wine + IE 6.
View 2 Replies
View Related
Aug 5, 2010
I have extra P4 PC (Dell Dimension 2400). And I would like to use this PC as NAS. What is the best way to make NAS from a PC.
View 3 Replies
View Related
