Back up From the Command Line (using mysqldump).Back up your MySQL Database with Compress.Restoring your MySQL Database.Open phpMyAdmin.Select your database by clicking the database name in the list on the left of the screen.Click the Export link.This should bring up a new screen that says View dump of database.In the Export area, click the Select All link to choose all of the tables in your database.
MySQL Import: How to restore your MySQL database from a backup. To restore (import) a database via phpMyAdmin, first choose the database you'll be importing data into. This can be done from the corresponding menu on the left. Then click the Import tab: You have the option of importing an .sql file. Choose the file from your local computer. Backup Database From the Command Prompt. It is a good idea to backup your MySQL data occasionally as a precautionary measure. It is also a good idea to create a backup before making any major changes, incase something goes wrong and you need to revert to the unmodified version.  Restore Process. Using phpMyAdmin, follow the steps below to restore a MySQL database. 1  Login to phpMyAdmin. 2  Click Databases and select the database that you will be importing your data into. 3  You will then see either a list of tables already inside that database or a screen that says no tables exist. 4  This depends on your setup. 1 Click Databases and select the database that you will be importing your data into. 2  You will then see either a list of tables already inside that database or a screen that says no tables exist. 3  This depends on your setup. 4  Across the top of the screen will be a row of tabs. My WAMP directory accidentally get deleted by another user. Only data folder in MySQLis available. And, in that only database-folders (folders in \bin\mysql\mysql5.6.12\data\ with name of databases) are available. All files including  ibdata1  in root of \bin\mysql\mysql5.6.12\data\ are also deleted.  This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server. 1  Back up From the Command Line (using mysqldump). 2  Back up your MySQL Database with Compress. 3  Restoring your MySQL Database. 1 Open phpMyAdmin. 2  Select your database by clicking the database name in the list on the left of the screen. 3  Click the Export link. 4  This should bring up a new screen that says View dump of database (or something similar). 5  In the Export area, click the Select All link to choose all of the tables in your database. mysqldump is an effective tool to backup MySQL database. It creates a *.sql file with DROP table, CREATE table and INSERT into sql-statements of the source database. To restore the database, execute the *.sql file on destination database. For MyISAM, use mysqlhotcopy method that we explained earlier, as it is faster for MyISAM tables. Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. Backing Up and Restoring using PHPMyAdmin. It is assumed that you have phpMyAdmin installed since a lot of web service providers use it. To backup your MySQL database using PHPMyAdmin just follow a couple of steps: 1  Open phpMyAdmin. 2  Select your database by clicking the database name in the list on the left of the screen. 3  Click the Export link. 4  This should bring up a new screen that says View dump of database (or something similar). 1 Open phpMyAdmin. 2  Select your database by clicking the database name in the list on the left of the screen. 3  Click the Export link. 4  This should bring up a new screen that says View dump of database (or something similar). 5  In the Export area, click the Select All link to choose all of the tables in your database. 1 Click the SQL link. 2  This should bring up a new screen where you can either type in SQL commands, or upload your SQL file. 3  Use the browse button to find the database file. 4  Click Go button. 5  This will upload the backup, execute the SQL commands and re-create your database. 1 Open phpMyAdmin. 2  Select your database by clicking the database name in the list on the left of the screen. 3  Click the Export link. 4  This should bring up a new screen that says View dump of database (or something similar). 5  In the Export area, click the Select All link to choose all of the tables in your database. You can use mysqldump to create a simple backup of your database using the following syntax. [ 1 username] – this is your database username. [ 2 password] – this is the password for your database. [ 3 databasename] – the name of your database. [ 4 backupfile.sql] – the file to which the backup should be written. You can backup only the database structure by telling mysqldump not to back up the data. You can do this by using the –no-data parameter when you call mysqldump. Compressing your Backup file on the Fly. Backups of databases take up a lot of space.
https://www.siteground.com/tutorials/php-mysql/mysql_export.htm http://php.about.com/od/learnmysql/ss/mysql_backup.htm https://codex.wordpress.org/Restoring_Your_Database_From_Backup http://dba.stackexchange.com/questions/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-ibd-files http://webcheatsheet.com/SQL/mysql_backup_restore.php http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump http://webcheatsheet.com/SQL/mysql_backup_restore.php http://webcheatsheet.com/SQL/mysql_backup_restore.php http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/
how to restore data from another database in mysql