Has anyone managed to get a back up without using db root?

[Steve]

Still havn't figured this out yet, guess I'll have to look in the code shortly.

I am using phpMySQLbackup for 2 different databases.

On one database I was able to extract the db root password from phpBB2 and the backup script works well.

With the other database I only have a user name and password with all priveliges but the script only returns the header, does it only work with the db root password and username?

[davidgwalker]

Hi Steve, and Welcome,

Using Root username is NOT a necessity.

Also, you can run backup several databases using the ONE install of phpMySQLAutoBackup, just copy the file:
/phpmysqlautobackup/run.php
and then rename to something appropriate, change the database name/username/password and it will backup the additional database when called.

Cheers

Dave

[Steve]

Thanks David

I did as you said, the result is

#Backup automated by phpMySQLAutoBackup
# from: http://www.DWalker.co.uk
#
# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Sep 04, 2005 at 07:08 AM
# Server version: 4.0.25
# PHP Version: 4.3.11
#
# Database : `my-db-name`
#


I know a table exists as I can access it phpMyAdmin. I know the user name and password are valid as I use them in the only script that accesses the database.

I am using CPanel to administer the site.

[lfhost]

is your database really named

Code: Select all

my-db-name

in cpanel they are usually named

username_DBname

[Steve]

No my db name is something else, no not literally

[lfhost]

ok, then when you receive the above dump, does it provide the correct DB name in the file or ?

[Steve]

yes the db name is correct and the username and password are the same that I use in the database connect statement in mu php script.