Skip to main content

How To take backup and restore mysql databases in Linux

To backup(dump) single mysql database to a file , first we need to open the terminal and use the below syntax
# mysqldump -u <username> -p <databasename> > backup.sql

Username = this is your database username
databasename = the name of your database which you want to backup
backup.sql = the filename for your database backup
Example:
# mysqldump -u root -p plist > /root/backuplist.sql
where -u is for username,
-p is for mysqldump to ask for password,
plist is the name of the database
backuplist.sql is the file to dump the database.
To restore back mysql database from dumpfile:
Method:1 Open the terminal , use below command
# mysql -u root -p plist < /root/backuplist.sql
-u and -p are similar to above, plist is the name of the database and backuplist.sql is the name of the dumpfile.
Method:2 From inside mysql console where we have to access mysql console first:
mysql> source backuplist.sql
or
mysql> \. backuplist.sql
where backuplist is the dumpfile

Comments

Post a Comment

Popular posts from this blog

Configure NTP (Network Time Protocol) on Windows Server 2008

The Network Time Protocol ( NTP ) in Windows 2008 provides your server with the ability to control the system clocks on your Windows client machines. This keeps all machines on the network synchronized with the same system time. This is beneficial for Windows administrators who need to schedule time-sensitive services on the network. You set the Windows 2008 NTP service in the registry. Step 1- Click the Windows 2008 “ Start ” button and enter “ regedit ” into the search box. Press Enter to open the Windows registry editor. Step 2- Navigate to the “ HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ Services\W32Time\Config\ “. registry key Step 3- Double click the key value labeled “ AnnounceFlags ” in the center detail pane. Step 4- Enter “ A ” into the DWORD value text box. Click “ OK ” to save your settings. Close the Windows registry editor. Step 5- Click the Windows “ Start ” button and enter “ cmd ” into the text box. Press Enter to open the command prompt. Enter...
Post a Comment
Read more

TI-RTOS Real Time Operating System for Microcontrollers

TI has released TI-RTOS , a real-time operating system (RTOS) for its microcontroller platform. This new RTOS helps developers by eliminating the need to write complex system software, such as file system, schedulers, drivers, and protocol stacks. TI-RTOS is provided with full C source code and requires no upfront or run-time license fees. TI-RTOS is based on existing components such as SYS/BIOS RTOS, controlSUITE, and StellarisWare software. The modular and scalable architecture enables system designers to chose sufficient modules/ functions and memory size as required. TI-RTOS Real Time Operating System for Microcontrollers Advertisement TI-RTOS is integrated into the TI’s CCStudio (Code Composer) IDE, which includes System Analyzer tools, enabling designers to view run-time application behavior including the sequence of thread execution and processor load. CCStudio IDE also has tools to assist multitasking debug. Designers  can use an object viewer (ROV...
Post a Comment
Read more