Overview Version:
– export the hosted database and download the .sql file
– ZIP the contents of the hosted site and download
– install a local server and start both the Apache and MySQL servers
– create a new, empty db on the local server and import the exported .sql file
– edit the siteurl and home fields to match your local site
– unZIP the hosted site ZIP in a folder in the local server web root
– edit the local wp-config.php for the local db credentials
– install and run a search-and-replace tool to update the hosted URLs of any media and other links to the local site … I use this one:
http://interconnectit.com/products/search-and-replace-for-wordpress-databases/
How do you export the hosted database? I am using an FTP to have access to all the website content files, but, where or how can I access to the database?
Thread Starter
Ryder
(@hyflex)
adminadminadmin
Typically it’s via the use of phpmyadmin located in your web hosting cpanel.
See: http://codex.ww.wp.xz.cn/Backing_Up_Your_Database
I don’t see any cpanel in my dashboard in the wordpress. What I can do maybe is download phpMyAdmin from the link from Hyflex and then export my database?
Thread Starter
Ryder
(@hyflex)
Your cpanel isn’t in wordpress, infact it’s the other way round.
If you’re hosted with bluehost for example it’s https://my.bluehost.com/ even though your site might be http://adminadminadmin.com/
Phpmyadmin (or similar) has to be installed on the remote server by your hosts. Try asking them about it.
