basics of mySQL
- Started
- Last post
- 3 Responses
- trooperbill
i need to know the basics of mySQL as i need to move a site from one host to another and dont know where to start anyone got any tips?
i assume that ill need to change a config file on the site to reference the new host (is it the same sort of details like those in the old wordpress setup?)
- 1pxsolid0
If you're moving a website, general steps are:
1. login to the current website's PhpMyAdmin
2. Find the export section where you can basically export the whole DB as a .sql file
3. login to the new website's PhpMyAdmin
4. Find the import section where you can import a .sql file.Once you've done that, copy all the files from the old to the new site.
And yes, after all that find the database config file and enter the new database details...
*in a nutshell
- trooperbill0
cool thanks... i hope phpmyadmin easy to use?
- 1pxsolid0
Indeed it is. Although it's quite ugly :)