Skip to main content

mysql

phpMyAdmin database export "Save as file" template

Posted Wed, 11/25/2009 - 11:18am

Whenever you do a database backup using phpMyAdmin, you are presented with a default file name structure for saves, usually like so:

__DB__

which basically gives you the name of the database you just backed up. Which is ok, however, most people would also like the date and time stamp included as well...

So...

This is how it's done... replace the above with :

__DB__-%F-%T

__DB__ = name of database Example: my_database
%F = Same as "%Y-%m-%d" (year-month-day) Example: 2009-11-25
%T = time stamp . (24 hour format, hour_minute_second) Example: 11_07_31

which will save a file with the naming structure similar to:

my_database-2009-11-25-11_07_31.sql

You can easily use other date/time structure, to suit your personal preference.

RESOLVED: mysqld won't start

Posted Sun, 06/21/2009 - 7:24pm

In case your mysqld won't work with

# service mysqld restart
or
# service mysqld start
or
# service mysqld stop

do this:

# killall mysqld

followed by: