If you don’t, use a MySQL username you know the password for in place of root. That will work if you know your root password. To get to a MySQL prompt from the command line, type “mysql –u root -p”. If your file was compressed, type: “gunzip ”.Type “cd /var/www/html/phpmyadmin/uploads” but use your own path of course. Before going to a MySQL prompt, go to the directory you uploaded your.
You can download the Putty interface from.
Using your favorite command prompt application, connect to your server.If you have not done this before, navigate to your PHPMyAdmin folder and create a new folder and name it whatever you want, but be sure to name it something memorable so you will know what it is for. For any WordPress site, I like to name the database something with “WordPress” or at least “WPS” in the name of the database, but just be certain that you use a unique name for your database so that you don’t risk overwriting any other database you may have on the same server!
See next steps for how to get to a MYSQL command prompt. Either change permissions or use the command line by typing “create database databasename ” at the command prompt. If you don’t see it there, then you do not have proper permissions set up in your phpmyadmin config file. Just click on “Home” then click the “Database” tab and towards the bottom of the page will be a “Create Database” field where you can add an empty database.
Below is a screenshot of the PHPMyAdmin export screen which you can find by clicking on the export tab in PHPMyAdmin: You can export large tables without any trouble, you just can’t import them. Most hosting providers and web servers have PHPMyAdmin, so take advantage of the simple export features. Simple is fast! I always stress that the simple way is often the best and fastest way, so keeping that philosophy in mind, here is how I migrate my larger WordPress databases from one server to the next: Using PHPMyAdmin to Export:
For example you will not want to try and use PHPMyAdmin with tables larger than 2mb because it will usually time out or cause other issues, but we will show you how to avoid this. There are some things you cannot do with WordPress database tables that exceed 2mb in size. In this WordPress tutorial, I will show you how to quickly and efficiently move a larger WordPress MySQL database from one server to another using the best techniques available today.