Linked Questions

3 votes
1 answer
3k views

"zip" a mySQL (phpMyAdmin) database [duplicate]

I've created a large database on my local WAMP webserver. I would like to send that database with all tables and table data to another computer. Is this possible? mySQL ver: 5.5.15 PHP ver: 5.3....
user3871's user avatar
  • 213
117 votes
5 answers
237k views

How to safely change MySQL innodb variable 'innodb_log_file_size'?

So I'm fairly new to tuning InnoDB. I'm slowly changing tables (where necessary) from MyIsam to InnoDB. I've got about 100MB in innodb, so I increased the innodb_buffer_pool_size variable to 128MB: ...
Derek Downey's user avatar
  • 23.5k
18 votes
3 answers
12k views

Why does importing a 12 GB .sql file take more than 36 hours?

I've been waiting now for 36 hours for a 12 GB .sql file to be imported with a simple type site.sql | mysql command. I can see the ibdata1 is growing still, currently nearly 40 GB. Considering the ...
servermanfail's user avatar
18 votes
4 answers
2k views

How do convert a 66,862,521 row table from MyISAM to InnoDB without going offline for several hours?

is it possible (and how) to convert a huge MyISAM table into InnoDB without taking the application offline. It requires to insert a couple of rows into that table every second but it is possible to ...
Hendrik Brummermann's user avatar
17 votes
3 answers
47k views

Any better way out of MySQL InnoDB log "in the future"?

I've got this InnoDB error in MySQL 5.0. Mysqld was stopped cleanly, but I managed to lose ib_logfile0 & ib_logfile1 afterward. Now after a clean startup, InnoDB has done its "crash recovery". ...
IcarusNM's user avatar
  • 581
9 votes
3 answers
26k views

Is possible to backup database online using rsync?

Some people tell me that the backup database on-the-fly using rsync is possible. I think it is possible but not safe because some log, buffer... is not flushed. Database is being recovered from the ...
Luke Nguyen's user avatar
3 votes
4 answers
16k views

When is Seconds_Behind_Master too big?

My mysql_slave got stuck on an error and built up to being 200,000+ Seconds_Behind_Master. Should I rebuild it and start from scratch, or let it catch up by itself?
vinhboy's user avatar
  • 309
8 votes
6 answers
8k views

Moving large databases

I have a centos server and /var/lib/mysql/ is 125GB (disk has 1GB free space). Ordinarily I would use mysqldump to backup the databases, but I don't normally work with such large databases, so I need ...
user2029574's user avatar
3 votes
2 answers
2k views

MySql replication with Raw Data and InnoDB tables

I want to start replication on DB that has many InnoDB tables and MyISAM tables. I did everything according to manual Creating a Data Snapshot Using Raw Data Files. Firstly, I tried copied all ...
com's user avatar
  • 606
1 vote
2 answers
3k views

MySQL Community Edition: Can I replicate my entire server with another server in one go?

I need to migrate all the databases from one server to another. There are about 100 databases, and all databases are used daily and updated/inserted too and read through their respective websites. ...
jason's user avatar
  • 143
2 votes
2 answers
1k views

Is there an easy way to copy one database to another

In MySQL? Say I have a local database. Now I want the remote database to mimic the local database. One way I can think of is to simply dump the database, upload and let things work. Well, database ...
user4951's user avatar
  • 1,365
1 vote
3 answers
2k views

Mariadb processes stuck after aborted dump restore. What to do?

I tried to restore a database dump on my local server. I have created the database locally myself. The dump creates the tables and insert all the data. I used 'source "C:\my_dump_file.sql"' to start ...
Toto's user avatar
  • 113
1 vote
1 answer
318 views

Duplicate table names after restoring a backup

I got this weird issue today when I restored a full .sql backup from one server to another server using dbForge Studio for MySQL (third party software). Both are having same properties like table ...
prasad's user avatar
  • 13