Open the file generated by Migrate DB in a text editor (whichever you use to create web pages), and copy all its contents into the text area in the SQL tab in phpMyAdmin, and click Go. In cPanel, go to Databases>phpMyAdmin, and click on the left-hand side on the database you just created. I recommend using the password generator (just make sure to paste it in a file so you don’t lose it, we’ll be copying and pasting other things on the next step).įinally, grant all permissions to the user you made, to the database. Also make it hard to guess, and at most 16 characters. This user will be just for the database, and nothing else. The next step is to add a user for that database. It must be at most 16 characters (including the prefix your host will assign to you). It has 3 steps:Įnter a name for your database. In cPanel, go to Databases>MySQL Database Wizard. Step 2: Create a Database and User in the Server We are going to uncompress the file later, anyway.Ĭlick the “Migrate” button, and save the file it generates somewhere handy. You can compress the file with gzip if you like, but if your site is not too large, you don’t need to. Notice how the “http:” is missing from the first address, but you do need the two slashes (“//”), and there is not trailing slash on either address. So, after entering both paths, it should look something like this (in this case, I’m installing in the root directory): As for the second field, the local path, you can find that in cPanel, in the left-side column, under WWW Directory: If it’s in a subfolder, enter that subfolder’s name as well in both paths. On the first field, enter the new URL of your site. What this plugin does is not just export the database, but it also replaces in your database all the URLs, so instead of pointing to something like they’ll point to. Once installed, and activated, go to Tools>Migrate DB. To export your local database, install in the Migrate DB plugin (you can search for it in Plugins>Add New and install normally). Modify wp-config.php to link WordPress to the new database.Move all your files from your local folder to the server.Import your local database into the server’s database.Create a database and user in the server.To achieve the move, we’ll need to follow these steps: FTP access to the server, or a way to upload files to your server (in cPanel>Files>File Manager).Migrate DB plugin (or similar) in your local installation.Access to the cPanel (or similar) on your server.The way I’m going to show, has worked well for beginners. There are many ways in which you can migrate your WordPress site from MAMP into its final home, to make it “live”. Posted Decemby Alicia Ramirez & filed under Tutorial, WordPress.
0 Comments
Leave a Reply. |