Mon, 29 Dec 2008 11:57:36 +0000
Category : Backup
How to restore large mysql database on windows platform without phpmyadmin? (no replies)
Hi
I had taken the backup of my wordpress blog which is being used on my site and its size is 32.62 MB and i try to restore the database through phpmyadmin but due to its largesize can't be done any more.
I had taken the backup of my wordpress blog which is being used on my site and its size is 32.62 MB and i try to restore the database through phpmyadmin but due to its largesize can't be done any more. Now i am going to try it out through command prompt on windows machine as i am not using a Linux machine.As i search it out only gets the UNIX/LINUX shell commands to restore our database.
I had taken the backup of my wordpress blog which is being used on my site and its size is 32.62 MB and i try to restore the database through phpmyadmin but due to its largesize can't be done any more. Now i am going to try it out through command prompt on windows machine as i am not using a Linux machine.As i search it out only gets the UNIX/LINUX shell commands to restore our database. Please tell me some dos commands or any other means through which i can restore my database on mylocalhost.
Please help me out.
Regards
Saurabh Ray [read more...] |
Fri, 26 Dec 2008 01:46:08 +0000
Category : Backup
Re : Backup of 25 GB data (2 replies)
Hi
I want to take a backup of 25 GB data.I am using the MyISAM storage engine.
Can anybody help me?
Thanks [read more...] |
Sat, 13 Dec 2008 15:42:22 +0000
Category : Backup
Mysqldump without view (1 reply)
Dear all
I want to take backup of database without taking backup of views.
what is the way to do that using mysqldump.
thanks [read more...] |
Wed, 10 Dec 2008 02:53:19 +0000
Category : Backup
Incremental backups using bin logs (3 replies)
All,
I'm using "flush logs" to do incremental backups (the MySQL manual recommends this method). So I'm doing the following every 15 minutes and rsync'ing the bin logs to another server.
/usr/bin/mysqladmin flush-logs
/bin/sleep 5 [read more...] |
Mon, 01 Dec 2008 22:01:51 +0000
Category : Backup
mysqldump output file has very long lines (2 replies)
Hi Mysql Experts,
I got a mysql dump file that has insert statements.
I got a mysql dump file that has insert statements. Each of them are very, very long, they have multiple rows for each line.
I got a mysql dump file that has insert statements. Each of them are very, very long, they have multiple rows for each line. Is there way to dump the SQL statements so that instead of one long line, it dumps multiple short lines. for example:
Instead of [read more...] |
Mon, 29 Dec 2008 21:28:44 +0000
Category : Backup
binary log per database (1 reply)
Is it possible to assign a different binary log file to different databases? What I'm thinking is like SQL Server where each database has it's own transaction log. We have a couple databases using the binary log and it gets large quick. If each db had it's own binary log the size would be more manageable. I would think restoring would be easier too.
Thanks,
Gunner [read more...] |
Wed, 19 Nov 2008 18:48:20 +0000
Category : Backup
mysqldump does not add the create/use database line (no replies)
I am using 5.0.67 Community and unless I add the --databases <database name> item onto the command line, no create and use database statements are in the dump. So when I try and restore it fails with "No database selected".
I am using 5.0.67 Community and unless I add the --databases <database name> item onto the command line, no create and use database statements are in the dump. So when I try and restore it fails with "No database selected". Everything I am reading says it should create those by default, no options required. These are InnoDb.
I am using 5.0.67 Community and unless I add the --databases <database name> item onto the command line, no create and use database statements are in the dump. So when I try and restore it fails with "No database selected". Everything I am reading says it should create those by default, no options required. These are InnoDb. Here is the command line to get the create/use statements in the output file. If I leave off the --databases it does NOT put the line in there:
I am using 5.0.67 Community and unless I add the --databases <database name> item onto the command line, no create and use database statements are in the dump. So when I try and restore it fails with "No database selected". Everything I am reading says it should create those by default, no options required. These are InnoDb. Here is the command line to get the create/use statements in the output file. If I leave off the --databases it does NOT put the line in there: mysqldump -u BUUser -p***** --flush-logs --opt --databases b787_sp_71o1_new > backup_dump_b787_sp_71o1_new_20081119_1108.sql [read more...] |
Sat, 15 Nov 2008 06:09:29 +0000
Category : Backup
Can't dump trigger (1 reply)
Hello,
I have 2 server, MySQL 5.0.45 (Ubuntu 7.10). Second, MySQL 5.0.51a (Ubuntu 8.04).
I dump my database routine with this same command [read more...] |
Thu, 13 Nov 2008 18:30:56 +0000
Category : Backup
The Umlaut Problem - How To Successfully Back Up And Restore MySQL Databases With Special Characters (no replies)
The Umlaut Problem - How To Successfully Back Up And Restore MySQL Databases With Special Characters
The Umlaut Problem - How To Successfully Back Up And Restore MySQL Databases With Special Characters http://www.howtoforge.com/the-umlaut-problem-how-to-successfully-back-up-and-restore-mysql-databases-with-special-characters-using-mysqldumper
The Umlaut Problem - How To Successfully Back Up And Restore MySQL Databases With Special Characters http://www.howtoforge.com/the-umlaut-problem-how-to-successfully-back-up-and-restore-mysql-databases-with-special-characters-using-mysqldumper http://www.howtoforge.com/the-umlaut-problem-how-to-successfully-back-up-and-restore-mysql-databases-with-special-characters-using-mysqldumper-p2
The Umlaut Problem - How To Successfully Back Up And Restore MySQL Databases With Special Characters http://www.howtoforge.com/the-umlaut-problem-how-to-successfully-back-up-and-restore-mysql-databases-with-special-characters-using-mysqldumper http://www.howtoforge.com/the-umlaut-problem-how-to-successfully-back-up-and-restore-mysql-databases-with-special-characters-using-mysqldumper-p2 http://www.howtoforge.com/the-umlaut-problem-how-to-successfully-back-up-and-restore-mysql-databases-with-special-characters-using-mysqldumper-p3 [read more...] |
Thu, 06 Nov 2008 21:28:22 +0000
Category : Backup
Restoring backup fails with "Incorrect key file for table" (no replies)
I did a dump of our db and im trying to import it onto a different system. Both running Mysql 5.0.67.
I did a dump of our db and im trying to import it onto a different system. Both running Mysql 5.0.67. 081106 13:17:49 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './jukefly_production/songs.MYI'; try to repair it
[read more...] |
Sat, 08 Nov 2008 13:36:25 +0000
Category : Backup
IB BACKUP tools for InnoDB (1 reply)
Hi,
We are planning to go for Enterprise Edition of MySQL server, i have question regarding backup solution for the database.
[read more...] |
Tue, 04 Nov 2008 18:53:53 +0000
Category : Backup
Backup innodb with mysqldump and locking (no replies)
For now I backup up my DB by running mysqldump with "--single-transaction" option on my master db server.
For now I backup up my DB by running mysqldump with "--single-transaction" option on my master db server. As far as I understand, this doesn't lock DB during backup; as far as I see my application can continue to read/write to DB without problem. And I don't see that average load on my linux box is high during backup.
For now I backup up my DB by running mysqldump with "--single-transaction" option on my master db server. As far as I understand, this doesn't lock DB during backup; as far as I see my application can continue to read/write to DB without problem. And I don't see that average load on my linux box is high during backup. Am I right or even with innodb and "--single-transaction" mysqldump produces some locks/overhead and runing backups in this way will be problematic when my DB will grow (for now it is just few GBs).
[read more...] |
Mon, 03 Nov 2008 17:06:41 +0000
Category : Backup
Creating MySQL Backups With AutoMySQLBackup (no replies)
Creating MySQL Backups With AutoMySQLBackup
http://www.howtoforge.com/creating-mysql-backups-with-automysqlbackup [read more...] |
Thu, 30 Oct 2008 12:30:11 +0000
Category : Backup
Cannot Restore Backup Dump File (no replies)
Hi ppl, greatings from Brasil ;)
[read more...] |
Thu, 23 Oct 2008 16:01:49 +0000
Category : Backup
mysqldump progress bar (no replies)
Hi,
[read more...] |
Thu, 23 Oct 2008 07:49:42 +0000
Category : Backup
Can't get it right (no replies)
Im trying to BackUp a Database Using VB.Net and i get an error.
Im trying to BackUp a Database Using VB.Net and i get an error. the error is "error: 1049: Unknown Database '-r' when selecting the database" [read more...] |
Mon, 20 Oct 2008 10:10:45 +0000
Category : Backup
mysqlhotcopy stop working (no replies)
Hi,
[read more...] |
Sun, 19 Oct 2008 13:39:14 +0000
Category : Backup
backup with encryption (no replies)
Dear All,
I am running a windows application using mysql. So I want to have an option for the user of the system to be able to backup the data with encryption. Is there an idea how I can do this ? [read more...] |
Sun, 16 Nov 2008 16:09:15 +0000
Category : Backup
Best recommendation for quick, automatic backup (3 replies)
Hello all.
[read more...] |
Thu, 16 Oct 2008 12:13:54 +0000
Category : Backup
Restore database outputs syntax error (no replies)
Hi,
[read more...] |
