Have an account?  Log In

Help! phpMyAdmin can't restore my database...It's too big!

Categories / Shared Hosting

icon

Admin User
Posted on 12/14/2010 12:00 am

This can happen as the HTTP post size is limited to a smaller number. The best way to restore your SQL database is by logging into SSH. Be sure that you've already created your MySQL Database from inside of the control panel.

  1. Upload your SQL file to your root directory /home/username*/
  2. Load up PuTTy or your favourite terminal client.
  3. Run the following command

    mysql -u your_mysql_user -p your_mysql_db < /home/username*/sqlfile.sql

  4. Enter in your database password and press enter.

Once completed it will return to bash.


* "username" is your login ID to cPanel.

How helpful was this article to you?
  • Currently 0.00/5
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 0 / 5 (0 votes cast)

Related Topics

Add a comment
Name:
E-mail:
Enter the code:
Copyright 2002 - 2013, ClientExec LLC. All rights reserved.