I tried to import my localhost database to live server but this happen
Looking at the screenshot, he’s doing the exact thing you said.
What is the size of Db?(Make sure it is less than 300mb)
Can you try to import it again?
sorry I don’t get it, my DB only 4mb
still same problem, half of them imported but the rest didn’t so I only can access home page
I tried import the DB to localhost its fine, but not for live server.
I still cant find the solution
the DB imported, but somehow that error pop up not sure why.
now I can access my website by replacing localhost or http://localhost to my own name website
As you are using WP, you have to edit the wp-config file…
Edit Your wp-config.php File
Navigate to your site’s files and in the root of your WordPress install, locate your wp-config.php file. In cPanel, edit the file by selecting it from the list and clicking the Edit button at the top of the page. If a pop-up appears, click Edit again.
You can also choose to download the file through FTP and edit it with a text editor. Either way, include your new database name by finding the piece of code similar to the one below:
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘your_db’);
/** MySQL database username */
define(‘DB_USER’, ‘yourusername’);
/** MySQL database password */
define(‘DB_PASSWORD’, ‘this-is-your-password’);
/** MySQL hostname */
define(‘DB_HOST’, ‘sql host’);
/** Database Charset to use in creating database tables. */
define(‘DB_CHARSET’, ‘utf8’);
Find define(‘DB_NAME’, ‘your_db’); in your file, where your_db is the original name of your database and change it to the new name you chose a moment ago.
Save the file and if you’re using FTP, upload the new file to the root of your install.
This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.