Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Confused maybe about MySQL Dump & PHP
Top Forums Web Development Confused maybe about MySQL Dump & PHP Post 302321980 by jzacsh on Tuesday 2nd of June 2009 12:51:12 PM
Old 06-02-2009
Question
Quote:
Originally Posted by otheus
You don't need to use --opt since it's enabled by default. 8000 items is not a lot. The "quick" option will not defeat the purpose of using bs=1M.
Thanks so much for your help. I'm trying to test this out on my personal live website's wordpress database first. so I uploaded a test.php file to run the shell script, like so:

test.php
Code:
<?php

$output=shell_exec('sh /home/jzacsh/public_html/private/scripts/dbackup.sh');

echo "<pre>$output</pre>";

?>

the shell script its set to run is:

Code:
#!/bin/sh

sql_bDir=./sql_pickup/

#START SQL BACKUP + TGZ 
echo " " #VISUAL PADDING
echo "# BEGINNING DATABASE BACKUP PORTION:" #VISUAL
    #MYSQL LANDING DIR. CHECK
    echo "Checking if sql backup landing directory exists: $sql_bDir"
    if test -d "$sql_bDir"
    then
        echo "Directory to receive database backup exists"
    else
        echo "Directory to receive database backup does not exist, creating it"
        mkdir $sql_bDir
    fi #ENDIF SQL DIR. CHECK

echo " " #VISUAL PADDING

# MYSQL BACKUP
sql_bName=SQLBackUp_$(date +%A).gz
sql_Path=$sql_bDir$sql_bName

echo "The Shopping Cart's database backup will be:" $sql_Path #NOTICE OF DATABASE BACKUP
echo "Note: If the main backup is backing up the root directory, you do not need to separately download the database backup."

mysqldump -u name -p wppass --single-transaction db123 | dd bs=1M | gzip -c > $sql_Path

then I visit the above ^ test.php via browser and get this output:
Code:
 
# BEGINNING DATABASE BACKUP PORTION:
Checking if sql backup landing directory exists: ./sql_pickup/
Directory to receive database backup exists
 
The Shopping Cart's database backup will be: ./sql_pickup/SQLBackUp_Tuesday.gz
Note: If the main backup is backing up the root directory, you do not need to separately download the database backup.

When I download the file its only 4KB, and upon unarchiving the file, I find a Zero KB file, which using "cat" via terminal shows that the file is indeed blank.

Any ideas what I could be doing wrong??
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Linux/Unix/PHP/MySQL & servers?

Hello everyone! First I would like to say that I am very glad that I found this forum, and by some of the posts I have viewed, I see that I can learn a lot from you all! Secondly, I know next to nothing about Linux/Unix (gotta learn sometime right?) and need some assistance. I am a... (5 Replies)
Discussion started by: kolton
5 Replies

2. UNIX for Dummies Questions & Answers

PHP & Apache & MySQL install how-to ?

how do i install php & mysql with apache on suse linux ??? apache was installed and configured when i installed linux. all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/ so how do i install php and get it to work with apache and... (4 Replies)
Discussion started by: perleo
4 Replies

3. Shell Programming and Scripting

PHP & MySQL: sort desending and print

How do i get php to sort the times in a table and print order desending. eg: in the table i have: 02:60.00 02:70.00 02:20.00 02:50.00 in that order in a table how do i get php & mysql to print... (1 Reply)
Discussion started by: perleo
1 Replies

4. Shell Programming and Scripting

restore mysql dump file in many remote servers?

Hi all, I want to restore DB file in many mysql servers, i already using script for sending the dumpfile in all servers, but it's just annoying if i have to restore the dumpfile in all servers, i want just execute 1 script, and will restore in all remote mysql servers. I make script but not... (2 Replies)
Discussion started by: blesets
2 Replies

5. Shell Programming and Scripting

how to break mysql dump sql file

Hi folks I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines. pls guide me how can i do that. Regards, Bash (2 Replies)
Discussion started by: learnbash
2 Replies

6. Web Development

[php] webpage with login & mysql-db

Hi all, What I was looking for before was a multi-user password manager, web-based! The offer of free or cheap tools of this kind is very pover. Or they are too complex (or too expensive) I'm not a web programmer but I now decided to set up a (php) website with login and based on this login... (1 Reply)
Discussion started by: thibautp
1 Replies

7. Shell Programming and Scripting

PHP read large string & split in multidimensional arrays & assign fieldnames & write into MYSQL

Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP. I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
Discussion started by: lowmaster
0 Replies

8. Shell Programming and Scripting

Can't add variable to file name in mySQL dump script

I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work. I get the error: $SOURCEDIR/p1db_$DATEVAR.sql:... (3 Replies)
Discussion started by: ojobson
3 Replies

9. Shell Programming and Scripting

Create mysql database with bash script - confused

Hi, i have the following: db="create database xxx;GRANT ALL PRIVILEGES ON xxx.* TO user@localhost IDENTIFIED BY 'password';FLUSH PRIVILEGES;quit;" mysql -u root -p$mysql_pass -e "$db" I don't understand why this is failing, it works fine when run from cmd but when is run in a bash script,... (1 Reply)
Discussion started by: ktm
1 Replies

LEARN ABOUT DEBIAN

gpodder-backup

GPODDER-BACKUP(1)						   User Commands						 GPODDER-BACKUP(1)

NAME

       gpodder-backup - Backup and restore utility for gPodder user data

SYNOPSIS

       gpodder-backup [--create|--extract] <archive.gpo.tar.gz> [options] gpodder-backup --purge

DESCRIPTION

       This utility can be used to create a dump of the current gPodder data (configuration files + downloads), optionally replacing the real con-
       tents of the download folder with zero-byte files (for submitting your data to a bug report without having to transfer lots of data).

OPTIONS

       --version
	      show program's version number and exit

       -h, --help
	      show this help message and exit

       -c <FILE>, --create=<FILE>
	      Create a new archive

       -x <FILE>, --extract=<FILE>
	      Extract an existing archive

       -f, --fake-downloads
	      Store downloads as zero-byte files in backup

       -n, --no-covers
	      Do not include cover files in archive

       -D <DIR>, --destination=<DIR>
	      Extract downloads in different folder

       -P, --purge
	      Remove current data (can be combined with --extract)

USAGE FOR BUG REPORTING

       This command is useful if you want to report a bug in gPodder:

       gpodder-backup --create bug123.gpo.tar.gz --fake-downloads
	      Backup your current data to file bug123.gpo.tar.gz, but don't store download data (create zero-size dummy files  instead).  You  can
	      then attach bug123.gpo.tar.gz to the bug report.

       If you are instructed to try gPodder from a "clean state", you can use the following command (be sure to backup your data before!):

       gpodder-backup --purge
	      Remove all gPodder data, so you can start from a clean state

EXAMPLES

       gpodder-backup --create today.gpo.tar.gz
	      Backup your current data to file today.gpo.tar.gz

       gpodder-backup --extract mybackup.gpo.tar.gz
	      Restore (without purging) the contents of mybackup.gpo.tar.gz

       gpodder-backup --extract default.gpo.tar.gz --purge
	      Remove current data, then restore the contents of default.gpo.tar.gz

       gpodder-backup --purge
	      Remove all gPodder data, so you can start from a clean state

EXTRACTING FAKED DOWNLOADS

       Please  note  that  any	existing  downloads will be overwritten with zero-byte files when using the --extract option of the gpodder-backup
       utility with a backup created with --fake-downloads

AUTHOR

       gpodder-backup was written by Thomas Perl (thp@gpodder.org)

gpodder-backup 1.0						   December 2010						 GPODDER-BACKUP(1)
All times are GMT -4. The time now is 11:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy