MYSQL Large Database Backup Via DirectAdmin

avx

Verified User
Joined
Oct 15, 2005
Messages
23
I backed up a database from directadmin and now I cant seem to restore it because its 37MB and When I try to upload it via direct admin it shows Page cannot be displayed is there any way how I can restore the database, I also tried it via PHP myadmin but it says no queries...
 
how do i import via command line can you please tell me step by step
 
avx said:
how do i import via command line can you please tell me step by step

Hire someone who knows how to do it, or pay someone who is willing to search for the answer.
 
Awww guys, I am only just past this stage, give him the benefit of the doubt!

1. Log in via SSH to your server
2. Type:

mysql -u username -pPassword database_name < path/db.sql

replacing username, password and database_name with the right ones and path/db.sql to the location of your uploaded sql file.

HTH
Ry
 
Back
Top