impoting .zip MySql files
Posted by: francoduina (---.maine.res.rr.com)
Date: June 22, 2010 04:29AM

From a web host I exported a MySql database as a .zip compressed file. When I use Wamp's phpMyAdmin to import the file, a message informs that the operation failed. What should I do?

Thanks.
Franco

Options: ReplyQuote
Re: impoting .zip MySql files
Posted by: yfastud (Moderator)
Date: June 22, 2010 05:42AM

should extract to get sql file instead

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides



Edited 1 time(s). Last edit at 06/23/2010 02:53PM by yfastud.

Options: ReplyQuote
Re: impoting .zip MySql files
Posted by: francoduina (---.maine.res.rr.com)
Date: June 22, 2010 03:27PM

Thanks, ifastud. But my database is bigger than the size allowed, so I'm forced to compress it. Is there any alternative?

Franco



Edited 1 time(s). Last edit at 06/22/2010 09:35PM by francoduina.

Options: ReplyQuote
Re: impoting .zip MySql files
Posted by: sheetal (---.129.93.111.tataidc.co.in)
Date: June 23, 2010 09:32AM

Hello francoduina ,

Put ur uncompressed sql file in wamp\bin\mysql\mysql5.1.32\bin folder .

Then on command prompt go to above path using CD comand.

Then put this line in front of that path>mysql -h localhost -u root -p database _name>urfile.sql

Here root is username of Phpmyadmin.Then enter password will come.Then enter ur phpmyadmin password.(most of the time it is blank.Just press enter).

Check ur database.Tables get created their.

Thanks,

Sheetal



Edited 2 time(s). Last edit at 06/23/2010 09:33AM by sheetal.

Options: ReplyQuote
Re: impoting .zip MySql files
Posted by: francoduina (---.maine.res.rr.com)
Date: June 23, 2010 03:38PM

Thanks Sheetal
Franco

Options: ReplyQuote


Sorry, only registered users may post in this forum.