I have downloaded the WAMP Server which includes the APACHE server, PHP, MySQL, PHP admin, then I FTP my wordpress website and put all of the files in the www folder of the WAMP.
Now, I would like to download the complete database from GoDaddy and put it somewhere. However, I am unsure of the procedures of
downloading the database and connecting it to wordpress.
I read that I should use PhpAdmin but I don't have experience with it. Any recommendation.
Any ideas on how to do this?
Thank you.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
you need to login to godaddy and try to manage your database from there. after you found phpmyadmin linked to your GoDaddy account you can export any database and save it to your computer. Then you will need to import the sql file you got from GoDaddy to your local mysql via phpmyadmin provided by wampserver.
Here are step by step instructions using PHPMyAdmin to backup your wordpress database.
http://codex.word
Found these instructions for GoDaddy
Once logged in to your GoDaddy account, follow these steps to locate your PHPMyAdmin interface.
QWJQ
Thank you all for your responses
I have follow the steps which resulted on a my database as a zip file, once I extracted I use phpadmin to imported but I did receive this error message
No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.
the sql file is only 5,109 KB
any idea
[quote]
then I FTP my wordpress website and put all of the files in the www folder of the WAMP.
[/quote]
it does not work that way, so you should follow this guide to install wordpress on wamp
http://blog.jlbn.net/?p=34
on your host, use phpmyadmin to export db and remember to save it as sql file; for example WordpressBackup.sql, then use phpmyadmin from wamp to import db for wordpress you just install by follow the guide above ;)
Hello
I did follow the following instructions:
Found these instructions for GoDaddy
Once logged in to your GoDaddy account, follow these steps to locate your PHPMyAdmin interface.
* My Account
* Hosting
* Manage Account
* Databases
* Under Action header, on the far right-side of the Database Name, select the button that reads, Open Manager
* Open Manager is the PHPMyAdmin feature
I also follow the instruction in reference of exporting the database as in this link http://codex.wordpress.org
Will when I export it the database did not exported as a zip file but I choose the none options
once I competed the import part still giving me the same following error
No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.
I did follow the instruction verbatim, It is getting confusing
I think I remember having your problem the first time I did this to but it was such a long time ago that I'm having a hard time remembering the solution.
I think it has something to do with either choosing the database you want to export, or choosing the tables you want to export.
What do you see when if you open the extracted file in a text editor (like Notepad). Do you see your data? I'm trying to isolate if the problem is with your Export or your Import.
When you go to Export the database, make sure you are actually exporting something. All your tables should be highlighted and the 'Save as file' template at the bottom should be __DB___
I attached a pic of what it looks like
View dump (schema) of database
mtzsw, here is the easiest way for you
1. follow this guide to install wordpress on wamp since it will not work when you copy wordpress folder from your host
http://blog.jlbn.net/?p=34
2. on your host, log into your wordpress dashboard
3. click on Tools
4. click on Export and make sure to select All Authors on Restrict Author
5. click on the button "Download Export File"
6. on local wordpress, log into your wordpress dashboard
7. click on Tools
8. click on Import
9. select Wordpress on the bottom
10. browse to select export xml file from host you've just downloaded
11. click on the button "Upload file and import"
12 check box "Download and import file attachments"
13. click the button "Submit"
Business Accounts
Answer for Membership
by: tbsgadiPosted on 2009-09-01 at 00:16:31ID: 25229142
Hi mtzsw,
Have a look at the following:
http://www.ehow.com/how_47
http://codex.wordpress.org
http://abeautifulwww.com/2
Good Luck!
Gary