how to import SQL dump for user?

vivithemage

• September 12, 2013 09:11

I have been trying to import an SQL dump, but am having no luck! I have been trying to use this, but no luck: [url=http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/]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

  • September 12, 2013 15:10

  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.

  0
• 

  vivithemage

  • September 12, 2013 15:46

  I do that, but nothing happens after I enter the PW really. root@xx[/home/seacoast/www/SQL_Dumps]# mysql -u seacoast_bigdump -p seacoast_typ32 < seacoast_typ32.sql Enter password: root@xx[/home/seacoast/www/SQL_Dumps]#

  0
• 

  cPanelMichael

  • September 12, 2013 15:47

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

  0
• 

  vivithemage

  • September 12, 2013 16:01

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

  0
• 

  cPanelMichael

  • September 12, 2013 16:16

  [quote="vivithemage, post: 1461082">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.

  0
• 

  vivithemage

  • September 12, 2013 16:21

  editing it in vi, all I see is: -- MySQL dump 10.11 -- -- Host: localhost Database: bigdump -- ------------------------------------------------------ -- Server version 5.0.96-community /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

  0
• 

  cPanelMichael

  • September 12, 2013 16:22

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

  0
• 

  vivithemage

  • September 12, 2013 16:34

  Thanks, that's probably the issue.

  0

Please sign in to leave a comment.