There's a whole list of all the functions at http://www.php.net
Curtis
On Thu, 4 Mar 2004, James Marcinek wrote:
> Rhino,
>
> I know this is an off topic; however I see that you have DB2 experience.
> Most of the information I have a question you might be able to answer. Are
> you using PHP with MySQL? If so, have you tried to use PHP with DB2? I'd
> like to know what functions you call to connect or anything that could
> help? I'm new to the MySQL arena as well.
>
> Thanks,
>
> James
>
> > Todd,
> >
> > I'm also pretty new to MySQL and Linux but I have years of DB2 experience
> > on
> > various platforms.
> >
> > I've bash scripts very useful and cron them when I have something that I
> > want to automate, such as a daily backup of my databases. Here are some
> > examples of bash scripts that I use with MySQL.
> >
> > This example, which is in file RI.sql, creates two related tables in the
> > MySQL 'tmp' database, populates them, and displays the results. NOTE: The
> > 'Another Mistake' row will not be successfully inserted into the 'emp'
> > table
> > because it has an invalid foreign key; there is no row for dept 'X99' in
> > the
> > 'dept' table.
> >
> > ---
> >
> > use tmp;
> >
> > drop table if exists dept;
> > create table dept(
> > deptno char(3) not null,
> > deptname varchar(36) not null,
> > mgrno char(6),
> > primary key(deptno)
> > ) Type=InnoDB;
> >
> > drop table if exists emp;
> > create table emp(
> > empno char(6) not null,
> > firstnme char(12) not null,
> > midinit char(1),
> > lastname char(15) not null,
> > workdept char(3) not null,
> > salary dec(9,2) not null,
> > primary key(empno),
> > index(workdept),
> > foreign key(workdept) references dept(deptno) on delete restrict
> > ) Type=InnoDB;
> >
> > insert into dept values
> > ('A00', 'Administration', '000010'),
> > ('D11', 'Manufacturing', '000020'),
> > ('E21', 'Education', '000030');
> >
> > insert into emp values ('000010', 'Christine', 'I',
> > 'Haas','A00',50000.00);
> > insert into emp values ('000020', 'George', 'W', 'Bush', 'D11', 30000.00);
> > insert into emp values ('000030', 'Another', ' ', 'Mistake', 'X99',
> > 15000.00);
> > insert into emp values ('000040', 'John', ' ', 'Kerry', 'E21', 35000.00);
> >
> > select * from dept;
> >
> > select * from emp;
> >
> > ---
> >
> > You can run the preceding script from the mysql prompt by preceding its
> > name
> > with '\.'. For example:
> >
> > mysql> \. RI.sql
> >
> >
> > This script, called backup2.bash, is what I use to back up my databases
> > each
> > night. It includes a comment showing the crontab entry I use to run it.
> > NOTE: We are using a Perl package called 'sendEmai'l instead of the
> > traditional 'sendmail' program.
> >
> > ---
> > #!/bin/bash
> >
> > #This script makes a separate database-level backup of each of the current
> > MySQL databases and
> > #deletes backups older than a certain number of days.
> > #This script is normally invoked via a cron job so that it runs once per
> > day
> > in the middle of the night.
> > #The crontab entry looks like this:
> > #0 3 * * * sh /home/rhino/MySQL/backup2.bash >
> > /home/rhino/MySQL/backup2.out
> > 2>&1; cat /home/rhino/MySQL/backup2.out | sendEmail -f [EMAIL PROTECTED] -t
> > [EMAIL PROTECTED] -u "Daily Backup Report"
> >
> > USERID="foo"; #The userid to use for creating the backup
> > PASSWORD="foopass"; #The password to use for creating the backup
> > BACKUP_TIMESTAMP=`/bin/date +%Y%m%d"-"%H%M%S`; #The timestamp
> > (YYYYMMDD-HHMMSS) of the backup
> > BACKUP_PATH="/home/rhino/MySQL/backup"; #The directory into which the
> > backup
> > will be written
> > NUMBER_OF_DAILY_BACKUPS_TO_KEEP=7; #The number of generations of backups
> > to
> > keep
> >
> > echo "** REPORT BEGINS **";
> > echo
> > echo "Program Name:" $0
> > report_date=`/bin/date`
> > echo "Report Date:" $report_date;
> > echo
> >
> > #Display the non-secret values used in this run.
> > echo "Backup Values:";
> > echo " Backup timestamp is" $BACKUP_TIMESTAMP;
> > echo " Backup path is" $BACKUP_PATH;
> > echo " Number of daily backups to keep ="
> > $NUMBER_OF_DAILY_BACKUPS_TO_KEEP;
> >
> > #For each database currently in MySQL, take a database-level backup, then
> > list any backups older than a certain number of day
> > for ONE_DBNAME in `echo show databases | mysql -s -u $USERID -p$PASSWORD`
> > do
> > echo
> > echo "Backing up database" $ONE_DBNAME;
> > /usr/bin/mysqldump --opt --verbose -u${USERID} -p${PASSWORD}
> > ${ONE_DBNAME} -r ${BACKUP_PATH}"/"${ONE_DBNAME}"."${BACKUP_TI
> > echo ">> Deleting these old backups for this database..."
> > /usr/bin/find ${BACKUP_PATH} -mtime
> > +$NUMBER_OF_DAILY_BACKUPS_TO_KEEP -name $ONE_DBNAME'*' -print; #display
> > old
> > backups (i
> > /usr/bin/find ${BACKUP_PATH} -mtime
> > +$NUMBER_OF_DAILY_BACKUPS_TO_KEEP -name $ONE_DBNAME'*' -exec rm '{}' ';';
> > #delete old
> > done
> >
> > echo
> > echo "** REPORT ENDS **";
> > ---
> >
> > If you want to take a backup manually with this script (and omit the email
> > being sent to you), you can do this from the mysql prompt via:
> > mysql> \. /home/rhino/MySQL/backup2.bash > /home/rhino/MySQL/backup2.out
> > 2>&1
> >
> > I think the biggest obstacle you're going to face in writing bash scripts
> > is
> > the lack of good tutorials on it. There are umpteen bash references that
> > show you generic syntax and tell you the terminology used by bash but
> > darned
> > few decent tutorials to show you how to write bash scripts. Some people
> > can
> > do anything they want with only a reference but I'm one of those people
> > who
> > need examples to really understand something so I've had real challenges
> > learning bash since the references are extremely skimpy on concrete
> > examples.
> >
> > Good luck!
> >
> > Rhino
> >
> > ----- Original Message -----
> > From: "HACKATHORN, TODD (SWBT)" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, March 04, 2004 8:57 AM
> > Subject: Scripting
> >
> >
> >> Hello,
> >> I am new to Linux, and mySQL. I am currently a MsSQL Server 2000 and VB
> >> programmer, but trying to break away from that side. I have my database
> > set
> >> up and working great, but I am really struggling on how to perform
> > scheduled
> >> updates, and data imports. Can anyone please point me to a good
> >> resource
> > to
> >> learn how to build a script, that can import data from an ODBC
> >> connection,
> >> and then maybe run multiple queries in the data one at a time. I don't
> > know
> >> what language I want to use because I don't know enough about it. Once
> >> I
> >> find a way to do what I need, I will learn that language. I think there
> >> might be a way to use php as cron'd scripts, but I don't know. Also I
> >> looked at perl, or just bash in linux. I am used to being able to do
> >> anything I needed to with DTS packages and stored procedures. I had ask
> >> a
> >> similar question a while back, and still can't get going with this. So
> > far
> >> the graphical packages for updates are the only thing I miss from SQL
> >> Server.
> >>
> >> Thanks in advance for any help.
> >>
> >> Todd Hackathorn
> >>
> >>
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
