[I Just Realised That Mail() Isn't Working Either....]

Did you get an email when you submitted the ticket?

Did you log back in to the help desk and look at your ticket?

 

I got a ticket and when I click on it it says "Error: Invalid email or ticket key" even when I type in the ticket key.

 

I'm really upset about this. I just opened up another ticket. The mail was working before their "System's update" and now it's not. My boss now want's to drop totalchoice because the whole thing was done without any warning. We lost people's invoices that were in the MySQL database. There was client projects in the html server, all lost and now noone responds to my questions.

 

[uPDATE]

Some one responded to the new ticket and all of a sudden the email is working. I'm waiting to hear what was wrong because my boss is expecting an answer as to what happened and what can be done to prevent this from happening again.

[Need mysqldump example]

You need to pre-fix your cpanel_name

 

$dbuser = 'CpanelName_myusername'; // Username to access MySQL database

$dbpass = 'CpanelName_mypassword'; // Password to access MySQL database

 

and change

$send_email = "no";

to

$send_email = "yes";

 

What do you mean by cpanelname.... your saying that, if for example, my username was "onelove" and my password was "password" that I have to write "onelove_onelove" for my username and "onelove_password" for my password?

 

Also I don't want it to send me an email, I wan't to be able to pass the created file to the logged in manager via a URL redirect.. but if no file exists, then this won't work, neither will emailing it.

 

I just tried it your way and this is what I got:

 

Warning: filetype() [function.filetype]: Lstat failed for (null) (errno=2 - No such file or directory) in /home/myusername/public_html/test/dbsender.php on line 85

 

Warning: fopen(/home/myusername/public_html/test/myusername_siteData-103006-0713pm_sql.tar.gz) [function.fopen]: failed to open stream: No such file or directory in /home/myusername/public_html/test/dbsender.php on line 91

 

Warning: filesize() [function.filesize]: Stat failed for /home/myusername/public_html/test/myusername_siteData-103006-0713pm_sql.tar.gz (errno=2 - No such file or directory) in /home/myusername/public_html/test/dbsender.php on line 92

 

Warning: fread(): supplied argument is not a valid stream resource in /home/myusername/public_html/test/dbsender.php on line 92

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/myusername/public_html/test/dbsender.php on line 93

Database backup created and sent! File name /home/myusername/public_html/test/myusername_siteData-103006-0713pm_sql.tar.gz

 

And then I checked my email and the gz file it references doesn't exist... it's a null string.

[Need mysqldump example]

Are you configuring the script correctly?

 

This is my file:

 

$dbhost = 'localhost'; // Server address of your MySQL Server

$dbuser = 'myusername'; // Username to access MySQL database

$dbpass = 'mypassword'; // Password to access MySQL database

$dbname = 'myDBName'; // Database Name

 

$use_gzip = "yes"; // Set to No if you don't want the files sent in .gz format

$remove_sql_file = "no"; // Set this to yes if you want to remove the .sql file after gzipping. Yes is recommended.

$remove_gzip_file = "no"; // Set this to yes if you want to delete the gzip file also. I recommend leaving it to "no"

 

$savepath = "/home/myusername/path_to_script/"; // Full path to this directory. Do not use trailing slash!

 

$send_email = "no"; // Do you want this database backup sent to your email? Fill out the next 2 lines

$to = "myemailaddress"; // Who to send the emails to

$from = "myemailaddress"; // Who should the emails be sent from?

 

$senddate = date("j F Y");

 

$subject = "MySQL Database Backup - $senddate"; // Subject in the email to be sent.

$message = "Your MySQL database has been backed up and is attached to this email"; // Brief Message.

 

No file is created, no errors give.

[I Just Realised That Mail() Isn't Working Either....]

Open a ticket at the help desk. I've just checked it on a couple of servers, and it's fine on those.

 

I did and no one has gotten back to me. I opened it at 4:40pm.

[Need mysqldump example]

Welcome to the forum, juliodm

 

See if there is anything in this thread will help you.

 

I installed the dbsender script and added my personal info for my site. The page shows no errors and doesn't do a thing. No file is outputed no errors are given, I get just a white screen.

[I Just Realised That Mail() Isn't Working Either....]

Any ideas what happened?

[Php Errors Are No Longer Displayed...]

Thanks, I'll try that.

[Need mysqldump example]

Hi Juliodm,

 

Welcome to the forums

 

Do you just want a backup? Go into backups, and select the database you want to backup.

 

If you want to do it as an export ...

Log into cpanel,

go into MySql Databases

At the bottom of the page, go into phpmyadmin

Select the database (on the left hand side)

Select Export, and the format you need.

 

Or do you need to do it as php? why? If you could explain a little more, we may be able to help.

 

Thanks for the welcome...

I need to set it up so that whenever a manager logs into my system, a php script will create a file and automatically force his browser to download it. I don't want to use cronjobs and I don't want to specify any tables, I need everything that exists in the one database file out as an sql file.

[Php Errors Are No Longer Displayed...]

Now if there is a PHP error, the page goes white and no errors are shown. What gives?

[Need mysqldump example]

Can anyone please write out a complete php working example of how to do a mysqldump?

PLEASE!