how to import SQL dump for user?

[vivithemage]

I have been trying to import an SQL dump, but am having no luck!

I have been trying to use this, but no luck:

Import MySQL Dumpfile, SQL Datafile Into My Database

I have tried via phpmyadmin, but it just hangs there on a white page after a few seconds. The .zip dump was only about 26mb.

 

[cPanelMichael]

Hello

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

mysql database_name < /path/to/database.sql

Or, if you need to complete the task as the username, you can run:

mysql -u username -p database_name < /path/to/database.sql

Thank you.

 

[vivithemage]

I do that, but nothing happens after I enter the PW really.

[email protected][/home/seacoast/www/SQL_Dumps]# mysql -u seacoast_bigdump -p seacoast_typ32 < seacoast_typ32.sql
Enter password:
[email protected][/home/seacoast/www/SQL_Dumps]#

 

[cPanelMichael]

That indicates the database dump was successfully imported into the database.

Thank you.

 

[vivithemage]

Nothing shows up, I wonder if the dmp is empty....

 

[cPanelMichael]

Nothing shows up, I wonder if the dmp is empty....

It's possible. You may want to review the dump file to see what it's contents are.

Thank you.

 

[vivithemage]

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]

Yes, it looks like that database dump does not contain actual database content.

Thank you.

 

[vivithemage]

Thanks, that's probably the issue.