Go Back   SolidHost Forums Support Forums Control Panel Questions

Reply
 
Thread Tools Display Modes
Old Jun 13th, 2006, 04:48   #1
Harold
Customer
 
Join Date: Aug 2005
Posts: 11
Default phpmyadmin importing

Hi guys,

The import button/link is missing in my accounts' phpmyadmin. It shows for me on another webhost. I'm planning to move an account with 140MB of mysql database from another host into my reseller account after the datacenter move this summer. I don't see how I can do that without the import option. I'm on the venus server.

Thanks!
Harold is offline   Reply With Quote
Old Jun 15th, 2006, 02:38   #2
dnc
Customer
 
Join Date: Nov 2004
Posts: 45
Default

You must firstly create the database (from cpanel, create database, create a user and then add the user with the appropriate privileges to the db).

Then, if you go in phpmyadmin and select your database, the import button will appear (under SQL section) !

But do not try to upload 140MB with phpmyadmin - it will simply timeout (I had tried with a 10-20mb db....)

You should upload the file to your home directory and then open a ticket and Solidhost will import the db via command line.
dnc is offline   Reply With Quote
Old Jun 15th, 2006, 06:39   #3
Harold
Customer
 
Join Date: Aug 2005
Posts: 11
Default

I tried that with some existing databases, and the import link wasn't to be found. I'll look again.

I've imported a 70MB database with my other host with no problem.

Thanks again.
Harold is offline   Reply With Quote
Old Jun 18th, 2006, 17:29   #4
Harold
Customer
 
Join Date: Aug 2005
Posts: 11
Default

I did this and I got an error when clicking "Mysql" Heres the links and buttons at the top of the DB phpmyadmin:

Server: localhost Database: smart_ubb7beta
Structure SQL Search Query Export Operations

No tables found in database.
Harold is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 21:03.