0
votes
1answer
45 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
17 views

Access Denied to Database Information_Schema

I have an SQL dump that is around 70GB in size with over a thousand databases inside of it. I am attempting to import it via command line, however I receive the error message... Access Denied for ...
1
vote
1answer
34 views

Import SQL Dump from Command Line

I have an SQL Backup that has hundreds of individual databases inside of it. The backup is around 70GB in size and I have spent countless hours attempting to restore it on a new machine due to the ...
1
vote
2answers
3k views

Error importing large MySQL dump file which includes binary BLOBs in Windows

I'm trying to import a MySQL dump file, which I got from my hosting company, into my Windows dev machine, and i'm running into problems. I'm importing this from the command line, and i'm getting a ...
0
votes
1answer
2k views

mysqldump doesn't create tables or import any data

I am trying to import a mysqldump into a new database. When I run: mysqldump -umydbuser -p --database testimport < database.dump I get the following output: Enter password: -- MySQL dump 10.11 ...