1
vote
1answer
50 views

MySQL import slowing, jbd2 high disk I/O

I'm importing a large .sql file into my servers MySQL Database, However the import has only so far imported a few tables and is currently on record ~17mill of one table. However the import pauses ...
0
votes
1answer
46 views

How to use screen with mysql import

I need to import a very large MySQL table on remote server. Usually I'm using mysql -u mysql_user -pMypass db_name < sql_data.sql But it takes about 5 hours to complete the task. I tried using ...
0
votes
0answers
75 views

Mysql dump wont import - Created on same version of mysql etc

I have a 2.2gb SQL dump that I need to import. I'm using the following: mysql -u myuser -p mydb < backup-20-june.sql Which i've used many times in the past. However this is what's happening, ...
0
votes
1answer
63 views

Updating the same .htaccess file on multiple sites

I manage 400+ wordpress blogs across 8 shared hosting accounts and I'm looking for a simple way to distribute changes to certain files. In particular, I want to push out the same .htaccess file to ...
0
votes
1answer
372 views

MySQL cancelled import - orphaned data in ibdata file

I was importing a database dump - almost 1GB worth: mysql -uroot -ppassword < mysqldump.sql When I received warnings that the hard drive was almost full. I panicked and Ctrl-Ced the import. ...
1
vote
1answer
178 views

getting syntax error while importing database backups in mysql

Hi I'am going to restore a database backup which has separated files for each table with same table name prefix, and the problem is when I try to import I get this syntax error: EERROR 1064 (42000) ...