Backing it up once every month or so makes sure you never loose too much of your work in case of a server crash, and it will make you sleep better at night. Click Export in the Menu to get to where you can backup you My Sql database. There should be as many tables in the export list as showing under the database name. Select"SQL"- for output format, Check "Structure" and "Add AUTO_INCREMENT" value.
It is easy and fast, so there is no reason for not doing it. Check "Enclose table and field name with backquotes". Check "Save as file", do not change the file name, use compression if you want.
As a WAMP user, you are familiar with php My Admin.
Like any application bundled with WAMP, php My Admin upgrades will be released. Simple, php My Admin will tell you in the right sidebar, along with a message across the bottom after you login.
You don't want to find yourself starting your library from scratch, and it's better to be safe than sorry.
All the content in the My Sql database must also be backed up. On the "SQL"-page , unclick the show query here again. NET Web (webmastering) Introduction to Cascading style sheets (CSS) The value of Alexa traffic rank HTML META tag, not a search engine optimization tool Create a maintainable webpage with modularization The www prefix in your domain name What is RSS and cool things RSS can be used for My Sql backup and restore with php My Admin Mix Computer related text Doing business (making money) with Information Technology Business with Computer Science Research in Computer Science Current and future possibilities of Medical Informatics Tasks that make sense to have automated Programming handheld mobile devices (overview) Security tips for the web surfer Price and Capacity in computer hardware Java RMI Tutorial.
Often this is because it is easier to manipulate the data in a spreadsheet and then create mass My Admin doesn’t allow you to update data from a CSV file directly.
You can import the data into an empty table, but you cannot update existing records.
A lot of web service providers say they do backup of all the files, but you should never blindly trust them.
If you have spent a lot of time making the content and it is only stored in the Mysql server, you will feel very bad if it gets lost for ever. Make sure that you have selected to export your entire database, and not just one table.