cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello :)

You can access your server via SSH as root and run the following command:

Code:
mysql database_name < /path/to/database.sql
Or, if you need to complete the task as the username, you can run:

Code:
mysql -u username -p database_name < /path/to/database.sql
Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
That indicates the database dump was successfully imported into the database.

Thank you.
 

vivithemage

Member
Jul 2, 2009
12
0
51
editing it in vi, all I see is:

-- MySQL dump 10.11
--
-- Host: localhost Database: bigdump
-- ------------------------------------------------------
-- Server version 5.0.96-community

/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
/*!40101 SET @[email protected]@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @[email protected]@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @[email protected]@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @[email protected]@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @[email protected]@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @[email protected]@SQL_NOTES, SQL_NOTES=0 */;
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Yes, it looks like that database dump does not contain actual database content.

Thank you.