recover database using backup controlfile until

as nvarchar set @SqlBackupDataBase =n ' BACKUP DATABASE YourDatabaseName to DISK = ' E:\DBBackup\YourDataBaseName-' + CONVERT (varchar (one), GETDATE (),) +replace ( CONVERT (varchar (), GETDATE (), 108), ': ', ') + '. Bak ' --backup file format: Yourdatabasename-20140626233410.bak Print @SqlBackupDataBase-Print out (omit for easy debugging) exec sp_executesql @

When you use phpMyAdmin to restore a database, you usually use the online upload function, the biggest bug is that if your network status is not very good, you probably accidentally interrupted the import or export operation.Locate phpMyAdmin in the installation directory config.inc.php file found:$cfg [' uploaddir '] = ' upload '; $cfg [' savedir '] = ' save ';These two parameters may or may not be empty by default, fill in the names of the two folde

#!/bin/bashpath=/bin:/sbin:/usr/bin:/usr/sbin:/usr/Local/bin:/usr/Local/sbin:~/bin export PATH export LANG=en_us. utf-8Savedir=/Log/database_bak/CD"$savedir" Time="$ (date +"%Y-%m-%d %H:%M:%s")"mysqldump-U [My_user]-p[my_pwd] [db_name] > [db_name]-"$time". sqlNote here that the following-p does not have spaces directly added [MY_PWD]The sh script is then placed in the/log/sh/directory and given execute permissions, and finally into the Linux timed task Crond, adding the following script:

The use of PHP code to implement database backup can make the site management becomes very convenient, we can directly into the background operation can complete the database backup.Key technologies: 1. First you have to get the tables in the database, the function mysql_list_tables (), and then you can save all the t