Tag Info

New answers tagged

0

If you have SSH access to the server, gzip the file to compress it, if it is not already compressed: gzip thefile.sql then copy it up to the server: scp thefile.sql.gz yoursshuser@example.com:~/ then SSH into the server and unzip it: gunzip thefile.sql.gz then import it using the MySQL command line: mysql -u yourdbuser -p yourdatabase < ...


1

When using MySql, I always recommend using https://www.mysql.com/products/workbench/. However, you do need to have some ports opened on your firewall, assuming you have one, and make sure your MySql is properly secured which can be found here: https://dev.mysql.com/doc/refman/5.7/en/security.html. If you do not have a firewall, then the process becomes that ...


0

You could break the huge file into smaller chunks. Just make sure you don't set the break in the middle of an SQL statement or you'll get errors.



Top 50 recent answers are included