search for: mysqldump

we have multiple servers approx 10 and each has about 100 GB of data in the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we take backup for these databases on to a remote machine and store them datewise , ( the remote machine is a 2TB HDD ) currently tar is not feasible as the data is too huge and the same goes with mysqldump suggestion will be of great help -- Regards Agnello D'sou...

...this machine .ssh/config is not being read, but only when ssh is run via rsync. My guess is this is just a problem with running the older rsync. Is that the case, and is there a workaround other than upgrading rsync? Here's some examples of how it's not reading my .ssh/config: "mysqldump" is the single-use key. You can see that rsync --rsh=ssh isn't reading .ssh/config: $ ls -ltu $HOME/.ssh/config /home/moseley/.ssh/mysqldump -rw------- 1 moseley users 668 Nov 11 06:45 /home/moseley/.ssh/mysqldump -rw-r--r-- 1 moseley users 268 Nov 11 06:45 /home/...

Hi all. I usally make backups of databases mysql. I make buckups of all datbase for example: mysqldump -u user -ppassword name_db > backups.sql also I make backups just its schema for example mysqldump -u user -ppassword name_db --no-data > backups.sql but now I need a backups incrementals, because the size of DB is very big (500 mb) How to make this? regards -- *Atte. Rodrigo Pi...

I need export an registers of a data base from command line. It is possible with mysqldump? for example: mysqldump -u user -ppass db "select *from users where id=20" ??? thank

I''ve got my applications running on a server that backs up every hour using MySQLdump. My goal is to take this ''dump'' and re-import it into my desktop computer using MySQLAdministrator. I go through the procedure of restoring this ''backup.sql'' file and it grinds for some time as though something is happening...and then nothing?? There are no error...

...ysql master service. This may involve reinstalling the mysql package, and, again, restoring the '/var/lib/mysql' and '/var/log/mysql' directories. In the case of losing the slave server, we have found instructions for rebuilding the slave database and restarting replication using a mysqldump backup taken from the master server. We have tested this and it works fine. However, I am having trouble finding out what to do should we lose the master server. Typically mysqldump backups of the master are done overnight, so a failure during the day would mean that the slave is ahead of the mast...

hello list, I am attempting to backup a centos 5.4 (x86_64) server running mysql with a cron job. Here's how the cron job looks: [root at cloud:/home/bluethundr/backupdb] #crontab -l * 3 * * * /usr/bin/mysqldump jfwiki > /home/bluethundr/backupdb/wiki-$(date +%Y%m%d).sql However if I run the command from the command line it seems to work fine. If I grep syslog for cron this is what I've found: Mar 4 22:12:13 domU-12-31-38-07-49-CC syslog-ng[1174]: Log statistics; processed='center(queued)=1...

Is it possible? It is mentioned in AWDWR but I cannot find that option in the MySQL documentation. I can dump the whole db or just the structure, but I''d like to be able to dump just the contents. bruce

...whall will happen? Shoud I override them? Remember, this is a PRODUCTION SERVER.. I should do it properly. I think I will have to do following steps. first, I will have to dump the mysql server backup from database server. This is the command I will have to enter from the database server. * mysqldump -u root -p databasename > database.txt* then, I will have to mount a flash drive and copy *database.txt* to the flash drive. Then, I will have to go to the web server and mount it there. Then, finnaly, I have to restore *database.txt* to web server as follows. *mysql -u root -p databasename...

What would be the best way to populate a development database for a Rails 3 app? I have looked at faker, but it seems that development has stopped, any other options? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To

...ting integer primary ID. The table is large (2.5 million records) and I''d rather not discard the contents. The composite_primary_key gem doesn''t appear to support altering the table with a migration to do its magic, only creating a table from scratch. So I dumped the table with mysqldump, ran the migration (table looks good), and am trying to repopulate the table. It has accented characters and is complaining about duplicates, apparently around words with and without accents, e.g., ''jose'' and ''josé''. I''ve been deleting one by hand from...

I just installed CentOS 3.5. Included in the install was mysql. When trying to start it using: service mysqld start. The system responds with mysqld not recpognized as a service. When trying to use /usr/bin/mysql I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). A search of the system does not reveal

.... So my question to you dear listers is if I do start using a locally mounted s3 bucket as my mysqld data dir, will performance of the database be acceptable? If so, why? If not are there any other reasons why it would NOT be a good idea to do this? The steps I have in mind are basically this: 1) mysqldump --all-databases > alldb.sql 2) stop mysql 3) rm -rf /var/lib/mysql/* 4) mount the s3 bucket on /var/lib/mysql 5) start mysql 6) restore the alldb.sql dump Thanks for your opinions on this! Tim 4) -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

How do I best migrate the data? For small databases I can text-edit the dump file from MySQL. The postgresql compatibility switch doesn''t help on mysqldump. Any ideas. Can MySQL export CSV that postgresql can import ? W Fred -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060429/dad4546b/attachment-0001.html

...sfer these files. My question is regarding MySQL dump files. From one backup to the next, I'd estimate that the MySQL data will be 90% consistent. So the dump file will have 10% new data. That new data will be scattered at random points through the file. Typically I'd pipe the output from mysqldump into gzip. Then I'd copy the gzipped file offsite. I wonder if saving the file uncompressed, and then using rsync to copy the file offsite will be more efficient. Any advice? Will rsync be effective at finding the 90% consistency between the new dump file and the old dump file? Will it be able...

...ple). We currently use Cobbler to do our base installs automatically and I am now looking at integrating Clonezilla with Cobbler. The goal is take an *individual* system that has been customized and migrate it in an automated fashion. We currently do this using Cobbler and then running rsync and mysqldump in a script along with other system -> userland module configurations (such as PHP modules) but the process is tedious and generally a PITA. We also must have the ability to run this across different datacenters on different continents. Any pointers to good automated solutions? References:...

...rge binary blobs. (Actually, it's the database of Mantis bug tracker [http://www.mantisbt.org/], with file attachments stored directly in the table rows. I know it's a bad idea from many other reasons, but let's say it was given to me as such.) First, I was dumping the database with mysqldump to an uncompressed dump and rsyncing it. Such a dump would use some 34G of disk space. My rsync took no less than two hours then, regardless of number of actual changes in the database. (Later I realized that my dump was perhaps not enough line-oriented, so I tried some --skip-extended-insert o...

Dne 4.2.2016 v 12:17 A J Stiles napsal(a): > On Thursday 04 Feb 2016, Marek ?ervenka wrote: >> hi, >> >> is there way to get SQL schema for Asterisk 13.7.0 without alembic? >> thanks > Assuming you already have Asterisk up and running, you can just use > > $ mysqldump -d -uroot DATABASE TABLE1 TABLE2 TABLE3 ... > > will print (on STDOUT, so you can just use > to write it to a new file, >> to > join onot an existing file or | to pass it through a program) the SQL > statements required to recreate the given tables in the given database. (If...

Hi. I get some strange results when using rename_column on a primary key in a migration. It seems like the migration script removes the auto-increment property if you rename a column. This is a minimal example. create_table :foo, :primary_key => :foo_id do |t| t.column "name", :string end # renaming the primary key makes auto-increment disappear. rename_column

...g Xen 3.2-1 / 2.6.18 on Debian Etch (Dom0). I setup a Dom0 with several DomUs (Linux). Each DomU disk is a LV partition. I have been seeing a few mails about backups and LVM and just wanted to make sure that what I am doing is correct. Each DomU with a database has a cron that dumps the db with mysqldump. Later on, Dom0 will do an LVM Snapshot of all DomUs and then do a file system backup of the Snapshots. I do no actions on the DomUs. No shutdown or ''xm pause/save/...'' Does this sound about right or am I missing something important? Any pointers to ''Xen backup'&...