Found a short script today and thought others here might find it useful. It connects to your MySQL server and exports a table as a tab delimited text file. Great if you’re trying to import your MySQL data into another program where normal SQL may not work.
addthis_url = [...]
Over the past few weeks WHM has been sending me emails that my server space was getting full. I guess 80% is the threshold for those emails. But it was creeping up so slowly that over the course of 8 or 10 weeks it had only gone from 80% to 82% which I [...]
Coppermine Gallery is a popular open-source photogallery script that’s used on sites all over the web. And it’s a very easy install.
Download the files
Head on over to the Coppermine home page to get the download file. Across the top you’ll see a link for Download. Click there to be taken to the SourceForge [...]
One of the support programs that comes with MySQL is an often overlooked program called mysqldump. With mysqldump you can easily dump a MySQL database to either CSV, XML, or a complete set of SQL instructions needed to recreate the database.
addthis_url = 'http%3A%2F%2Fforumsblogswikis.com%2F2007%2F06%2F01%2Fmysqldump-backing-up-your-database%2F';
addthis_title = 'mysqldump+-+Backing+up+your+database';
[...]
How often do your online databases get updated? How often do you back up? Are you dependent on your host for backups? Try this quick PHP script to backup your MySQL databases from your server.
The general rule of thumb for backups is backup often enough to where you wont mind losing the work [...]