At the SSH Unix / Linux prompt type:
mysqldump -u username -p databasename | mysql -u username -p database
You will be prompted to enter each database password.
the first mysql database will be copied to the 2nd mysql database.
Make sure you have already set up the database name and username and password before you attempt this.
From the Linux shell prompt via SSH type:
/usr/bin/mysql –user=schoolco_scott –password=scott08 –database=schoolco_schoolco –table=temp_image < /home/schoolco/public_html/image.sql
<?php
$name = “Web Guy”;
$email = “sender@emailaddress.com”;
$recipient = “recipient@emailaddress.com”;
$mail_body = “This is the email text”;
$subject = “This is the email subject”;
$header = “From: ” . $name . “<” . $email . “>\r\n”;
mail($recipient, $subject, $mail_body, $header);
?>
Cron Job is a Unix/Linux command that automates tasks. It works well to automate PHP Scripts.
Cron comes from the word Chronology.
Crontab Format
minute hour day month weekday command
30 22 15 1 * /home/user/script.php
The command above runs script.php at 10:30pm on 15th January.
An asterisk in any field means all values so 0 18 * * * /script.php [...]
Safari books Online offers a very powerful service offering online e-books in HTML and PDF downloadable formats. It has a massive searchable database and various subscription options. Global Link has an ongoing subscription.
They provide books on all the latest books on Information Technology. Global Link focuses on their web development library which provides resources on [...]
In order to run MYSQL from the command line on your web server, you need SSL enabled for your account.
With a shared web hosting account, you do not have root access, so you will need to contact your host to make sure they can enable SSL. It will probably be Jailed SSL.
If you do not [...]
log into MySQL
$ mysqldump -u username -p databasename > database.sql
You will be prompted for your mysql password. Your database will be backed up to the file named database.sql. Note you can name the database file anything you choose.
Welcome to our blog. We will be covering all topics having to do with web design and development. We’ll be covering ecommerce web development, shopping cart systems, web site design, search engine optimization, database design and much more.
We will also be discussing MySQL, PHP and other technolologies related to web site design.
Please check back soon [...]
