How to IMPORT DATA INTO YOUR MYSQL DATABASE

 To import a sql file to an existing mysql database hosted on your account:


%/usr/local/nf/bin/mysql --force --quick -h mysqlhost -uUsername -pPassword DatabaseID < File.sql

$ mysql -uUser_vbforum -pPass_vbForum < /home/emad/public_html/databaseName_Backup_06-12-1429_11-55.sql


$ mysql -uVbforum -pVbForum2 < /home/emad/public_html/bahattab_06-12-1429_11-55.sql


NOTE: If you encounter a "max_questions" error, you should redo your mysql backup using the -e switch as in the example above. Then try the import command again.


IMPORTING TABLES INTO YOUR MYSQL DATABASE:
To import a table to an existing mysql database hosted on your account:


% /usr/local/nf/bin/mysql --force --quick -h mysqlhost -uUsername -pPassword DatabaseUD tablename < tables.sql


NOTE 1: For additional help in mysql commands: %mysql -h


NOTE 2: Commands such as myisamchk and grant are not permitted by users for security reasons.



SCHEDULING YOUR DATABASE BACKUPSTo create a cron job to schedule your database backups please click here for further instructions.