Importing a large database problem in phpmyadmin

Hello,

I'm hoping someone could help me with my problem. I have a large database (62mb) in sql format which I wanted to "Import" but everytime I try to import it in phpmyadmin, I get this error:

Error
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

Can you walk me through step by step and tell me how to upload this database? Please let me know. Thanks in advance

 

Quite often depending on your host, they will ask you to ftp the database to your root directory and then they will import it for you. It's because there is a limit set for uploading MySQL databases, which is set depending on what your host sets it to. The other way around it if you have the facility is to SSH it. Also consider using MySQL administrator, its a GUI database importer and can be download from the MySQL website.

 

Thanks for responding so quickly justingh

I am interested in knowing more about MySQL adminstrator. Would that be in Cpanel itself? Or...

 

here is the download link http://dev.mysql.com/downloads/gui-tools/5.0.html

Just download this and install it. Then simply run the program and enter your domain name, database name and password.

Example

domain.com
site_dbase
pasword

Then you can simply import the database using this program. Let me know if you need any more help

 

Sounds good, I'll give that a try. Thanks so much for taking the time to help me. I'll let you know how it works out

 

No problem, Glad I could help

 

Hi justingh

I downloaded and installed MySQL Administrator 1.2.15 for windows.

After launching the program, it opens a box asking me for these info:

Stored Connection: __________
Server Host: ___________ port:3306
Username: ____________
Password: ____________

I'm unsure what to enter here. Do I enter my domain name in Server Host field? database name in Username field? What do I enter in the Password field? Shouldn't it be asking me for a database username as well if it wants to access?

Or am I completely off base and I have to enter my server login details in those fields.

I tried both but I'm getting an error on connection.

 

if you have access to the command line/ssh, its much easier to import large mysql databases

 

@StarScream,
You probably received that error because the server was not configured to allowed remote requests.

Try this workaround:
1. Find your (WAN/internet) IP address.
2. Login into cPanel and see the section "Remote MySQL". Enter your IP address there in the host field and then try again!
3. Once importing is complete, remember to remove the remote IP address permissions.

Just tried this on my server and it works

 

good info thanks

 

search for bigdump , its all what u need

 

zip the db and then import it in gzip format

If that does not help

devide the file in 10 parts using manual selection of statements and execute them

one by one


Regards

Alex

 

I downloaded and tried using the bigdump software but I get this error below from it tries to import the sql file.

BigDump: Staggered MySQL Dump Importer v0.29b
Processing file: test.sql
Starting from line: 1

Error at the line 40: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Query: CREATE TABLE `wp_comments` (
`comment_ID` bigint(20) unsigned NOT NULL auto_increment,
`comment_post_ID` int(11) NOT NULL default '0',
`comment_author` tinytext NOT NULL,
`comment_author_email` varchar(100) NOT NULL default '',
`comment_author_url` varchar(200) NOT NULL default '',
`comment_author_IP` varchar(100) NOT NULL default '',
`comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_content` text NOT NULL,
`comment_karma` int(11) NOT NULL default '0',
`comment_approved` varchar(20) NOT NULL default '1',
`comment_agent` varchar(255) NOT NULL default '',
`comment_type` varchar(20) NOT NULL default '',
`comment_parent` bigint(20) NOT NULL default '0',
`user_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`comment_ID`),
KEY `comment_approved` (`comment_approved`),
KEY `comment_post_ID` (`comment_post_ID`),
KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
KEY `comment_date_gmt` (`comment_date_gmt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

MySQL: Table 'wp_comments' already exists

 

Rohan, I also tried your method, I found my IP address, went into Remote SQL and entered my IP address and saved it but I'm unsure what to do next?

 

You get that error because you already have that table

 

I deleted the table but it made no difference as I got a new error now.

BigDump: Staggered MySQL Dump Importer v0.29b

Processing file: test.sql

Starting from line: 1

Stopped at the line 398.

At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.

Stopped on error


Any ideas or suggestions on what to do next?

 

This stinks, its too hard for a newbie rent a php coder