One of my staff asked me on how to upload a 345MB SQL dump file he extracted from one of our DB servers to another server. He told me that he is having a problem doing this task using PhpMyAdmin because of the 2MB limitation found PhpMyAdmin’s import screen.
I know that the procedure below is very basic to others but still, allow me to give you the easiest way on how to upload an SQL dump file to another server:
- Upload the .SQL dump file to your target MySQL server via FTP or SFTP.
- Type the command below:
mysql --user=username –password=password DB_name < dumpfile.sql - Congratulations!
NOTES:
- The command used above will upload the table(s) and records inside dumpfile.sql to an existing database named DB_name.If the “CREATE TABLE” portion in the dumpfile.sql is present then it will create the table(s) inside DB_name, provided that the table(s) is (are) not yet in the DB_name.
- If the table(s) is (are) already in the DB_name and you just want to insert records inside the table(s), you need to remove the “CREATE TABLE” portion inside the dumpfile.sql. Just make sure that the fields of the existing table are the same with the fields in the dumpfile.sql you want uploaded.
Popularity: 2% [?]
Samba is a free software re-implementation of SMB/CIFS networking protocol, originally developed by Australian Andrew Tridgell. Samba is released under the GNU General Public License. The name Samba comes from SMB (Server Message Block), the name of the standard protocol used by the Microsoft Windows network file system.
The pagefile.sys file is the Virtual Memory file used by your Windows computer. If you have limited RAM, your windows machine to run programs and store data. It swaps out some of the RAM data to the page file and then reuses the freed up RAM.






































