|
|
|
Encrypt HTML - HTML Encryption - HIDE SOURCE CODE
PLEASE VISIT WWW.HTMLBLOCK.CO.UK FOR HTML ENCRYPTION AND ANONYMOUS EMAIL SERVICE! Welcome to htmlblock.co.uk Protecting Websites Worldwide Protect your website with htmlblock.co.uk. Our software package gives you the highest in encryption and...
How Antivirus Software Works and What it Does
You have permission to publish this article electronically or in print, free of charge, as long as the bylines are included and all links are made active. A courtesy copy of your publication would be appreciated: published@antivirus-report.com ...
Introduction to ASP.NET with C#
Introduction: In this tutorial we will introduce the new technology for building websites. This new technology is known as Asp.net. Asp.net allows the developer to build applications faster. This is achieved due to the fast that Asp.net makes use of...
Microsoft CRM Implementation - US market lessons
Microsoft CRM is CRM answer from Microsoft Business Solutions. If you compare it to other traditional CRM applications, such as Siebel - you will see that Microsoft CRM does use all the resent Microsoft technologies, that means that Microsoft...
Starting your desktop publishing project at the end
The only place where you can find the beginning to start at the end is during a typical desktop publishing project. As one designer would relate, for all practical purposes, the process of culling information starts at the end in the printing...
|
|
| |
|
|
|
|
Backing Up And Restoring Your MySQL Database
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
Backing up your database
The quickest and easiest way to backup and restore your database would be to use MySQLDump. If you've got shell or telnet access to your server, you can backup MySQL data by issuing the mysqldump command. The syntax for the command is as follows.
mysqldump -u [uname] -p [pass] [dbname] > [backupfile.sql] [uname] - this is your database username [pass]- this is the password for your database [dbname] - the name of your database [backupfile.sql] - the filename for your database backup
To backup your database 'Customers' with the username 'sadmin' and password 'pass21' to a file custback.sql, you would issue the command
mysqldump -u sadmin -p pass21 Customers > custback.sql
Issuing this command will backup the database to custback.sql. This file can be copied to a safe location or a backup media and stored. For more information on MySQLDump, you can check out :
href="http://www.mysql.com/doc/en/mysqldump.html" target="new">http://www.mysql.com/doc/en/mysqldump.html
Restoring your database
If you have to re-build your database from scratch, you can easily restore the mysqldump file by issuing the following command. This method will not work if the tables already exist in your database.
mysql - u sadmin -p pass21 Customers < custback.sql
If you need to restore existing databases, you'll need to use MySQLImport. The syntax for mysqlimport is
mysqlimport [options] database textfile1
To restore your previously created custback.sql dump back to your Customers Database, you'd issue
mysqlimport -u sadmin -p pass21 Customers custback.sql
For more information on MySQLImport, you can check out : http://www.mysql.com/doc/en/mysqlimport.html
Vinu Thomas is a consultant on Webdesign and Internet Technologies. His website is http://www.vinuthomas.com. You can discuss about this article or any PHP/MYSQL related issues in our Discussion Forums: http://www.vinuthomas.com/forum2.html
|
|
|
|
|
|