Confused maybe about MySQL Dump & PHP Post: 302322081

Sponsored Content

Top Forums Web Development Confused maybe about MySQL Dump & PHP Post 302322081 by jzacsh on Tuesday 2nd of June 2009 06:27:09 PM

06-02-2009

Registered User

Quote:

Originally Posted by otheus

1. change sql_bDir to $PWD/sql_pickup/ so we can see where at actually outputs.
2. for testing, turn off compression and skip the dd command... output directly to the file.

okay, done. didn't seem to make a difference Smilie

(the file still comes out 0 B, just uncompressed)

test.php 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
Note: If the main backup is backing up the root directory, you do not need to separately download the database backup.

source of dbackup.sh

Code:

#!/bin/sh

sql_bName=SQLBackUp_$(date +%A)
mysqldump -u jzacsh_jzacsh -p wordpres --single-transaction jzacsh_jzwp  > $PWD/sql_pickup/$sql_bName

actually... just in posting that ^ I realized I haven't checked:
echo $SHELL

...it returned
/usr/local/cpanel/bin/noshell

i'm guessing that means I can't run things properly? (I'm not sure, I obviously had a shell to output a file with and everything... I just wasn't successful in outputting a GOOD file)

jzacsh

View Public Profile for jzacsh

Find all posts by jzacsh

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...

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...

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...

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...

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

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...

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...

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:...

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,...

LEARN ABOUT CENTOS

idevicebackup2

idevicebackup2(1)					      General Commands Manual						 idevicebackup2(1)

NAME

       idevicebackup2 - Create or restore backups for devices running iOS 4 or later.

SYNOPSIS

       idevicebackup2 [OPTIONS] CMD [CMDOPTIONS] DIRECTORY

DESCRIPTION

       Create or restore backup from the current or specified directory.

OPTIONS

       -u, --udid UDID
	      target specific device by its 40-digit device UDID.

       -s, --source UDID
	      use backup data from device specified by UDID.

       -i, --interactive
	      request passwords interactively on the command line.

       -d, --debug
	      enable communication debugging.

       -h, --help
	      prints usage information.

COMMANDS

       backup create backup for the device.

       restore
	      restore last backup to the device.

	    --system
	      restore system files, too.

	    --reboot
	      reboot the system when done.

	    --copy
	      create a copy of backup folder before restoring.

	    --settings
	      restore device settings from the backup.

	    --remove
	      remove items which are not being restored.

	    --password PWD
	      supply the password of the source backup.

       info   show details about last completed backup of device.

       list   list files of last completed backup in CSV format.

       encryption on|off [PWD]
	      enable or disable backup encryption.

       changepw [OLD NEW]
	      change backup password on target device.

AUTHORS

       Martin Szulecki

       Nikias Bassen

SEE ALSO

       idevicebackup(1)

																 idevicebackup2(1)