WampServer
Apache, PHP, MySQL on Windows
Home forum
Back to WampServer
presentation
Downloads
Addons
Trainings
Alter Way
Go to Topic:
Previous
•
Next
Go to:
Forum List
•
Message List
•
New Topic
•
Search
•
Log In
•
Print View
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:
Reply
•
Quote
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:
Reply
•
Quote
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:
Reply
•
Quote
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:
Reply
•
Quote
Re: impoting .zip MySql files
Posted by:
francoduina
(---.maine.res.rr.com)
Date: June 23, 2010 03:38PM
Thanks Sheetal
Franco
Options:
Reply
•
Quote
Go to:
Forum List
•
Message List
•
Search
•
Log In
Sorry, only registered users may post in this forum.
Click here to login