How to setup a database using the MySQL Database Wizard in cPanelThis demo assumes you've already logged in to cPanel, and are starting on the home screen.Now let's learn how to setup a database using the MySQL Database Wizard.Click the MySQL Database Wizard icon.Enter a name for the new database, then click Next Step.Now we have to create a user for this database. Enter a username and create a password, then click Create User.Click the All Privileges check box, then click Next Step.That's it! My MySQL database has been created, and the new user added to the database. The database name, username and password will all be needed for scripts that need to connect to the database.Now click the MySQL Databases icon on the main page.Here you can see the new database you just setup.This is the end of the tutorial. You now know how to setup databases using the MySQL Database Wizard.
Renaming database tables with phpMyAdmin This video assumes you've already logged in to phpMyAdmin. Now let's learn how to rename a database table. First, select the database where the table exists... ... then click the table you want to rename. Click the Operations tab. Under Table Options, in the Rename table to section, enter a new name for the table, then click Go. That's it! The table has been renamed, as can be seen here in the left pane. This is the end of the tutorial. You now know how to rename a database table with phpMyAdmin.
Deleting a table from a database with phpMyAdmin This video assumes you've already logged in to phpMyAdmin. Now let's learn how to delete a database table. First, select the database where the table exists. Select the table by checking its checkbox... ... then click Drop. Click OK to confirm. That's it! The table has been deleted, as well as all fields and data within the table. This is the end of the tutorial. You now know how to delete a database table with phpMyAdmin.
Exporting databases and tables with phpMyAdminThis video assumes you've already logged in to phpMyAdmin.Now let's learn how to export databases and tables.First, select the database you want to export...... then click the Export tab.If you want to export the entire database including all tables within, leave the Quick export method selected.In this case we want to export the database in SQL format so we can easily import it later. This is a good way to back up your database.When ready, click the Go button.A complete copy of your database will be downloaded to your computer.If you want more options before exporting, click the Custom export method.Here we can select which tables to include...... and we can rename our exported file .There are many other options we could choose, but in most cases we'll just want to keep the defaults.When ready, click Go.That's it! A copy of your database will be downloaded to your computer, as per the options you chose.This is the end of the tutorial. You now know how to export databases and tables with phpMyAdmin.
Importing databases and tables with phpMyAdmin This video assumes you've already logged in to phpMyAdmin. Now let's learn how to import databases and tables. First, select the database you want to import. Let's assume the data in our details table is corrupt, and we want to import a recent backup (or exported copy). Therefore, let's first delete the existing details table from the database. Now let's import the recently exported copy of our database, which includes the details table. Click the Import tab... ... then click Choose File and locate the file we want to import. When ready, click Go. That's it! The database has been successfully imported. We can see here that our details table has been restored. This is the end of the tutorial. You now know how to import databases and tables with phpMyAdmin.
.png "Microsoft Visio")
.png "VMware")
