Mysql, PHP & UNIX Resource
DATABASE BACKUP
1- Login with Putty
2- command Line
mysqldump –-user admin –-password=password mydatabase > sql.dump
Browse Information
$sql ="Select * from table";
$result= mysql_query($sql);
while ($row = mysql_fetch_assoc($result))
LOAD FILE
LOAD DATA LOCAL INFILE [FILE_NAME] INTO TABLE [TABLE_NAME] FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 LINES;
CONNECT DB SSH (PUTTY)
mysql -u [USER] -p
use [DATABASENAME]
GUNZIP & GZIP
gunzip -d [FILE] <----- (DESCOMPRESS)
gzip [FILE] <---- (COMPRESS)
Cheap web hosting, domain hosting, budget web hosting
Description: powerhoster.com provides window web hosting, linux web hosting, dedicated web hositng, reseller hosting and domain registration service.
Remember, if you are look for web designing or hosting then do check hosterio. Hosterio is a reseller Web Hosting company which provides web designing services, ecommerce services and domain registration services. Web Design starts from as low as $149 only.
After selects, unions, inserts and updates? Do you have time visit a new website? Yes? Nice! Well when you visit the Craigslist website, the home page that greets you is nothing more than a grey page filled with blue text and a smattering of a bit of white and yellow.
Now again, time to work, what is UNION? and how to use it? with UNION you can get data from different tables for example, you have the table animals and the table pets, and you want to retrieve all the animales and pets in one query. you can do select * from animals UNION ALL select * from pets, remember all the columns need to have the same name, if some column has a different name you can use AS to replace the name for example select name as animal_name from animal, the new column name is animal_name, really is too easy to create nice queries.
I'm sure in this site OneFinancePlace is using mysql to retrieve information, as you can see many websites are using mysql and php to get date from database, really is very easy use mysql and php in websites.
Mobile Phones
Get latest mobile phones and best deals on mobile phones from orange, T-mobile, 3, o2 and Vodafone. Mobile phones including, Nokia, Sony Ericsson, Samsung, LG and Motorola.
Do you have free time after learn a lot mysql? Now it time to Purchase original canvas art prints available at Wallcreate.
Need help after work and learn mysql hard?
UK's premier banking and financial expert ombudsman to help you reclaim bank charges and penalty charge with a success rate to date of 100%.
Making You Richer.com review - best affiliate internet marketing training mentoring program – showcasing how to make top dollars, become super affiliate with top internet marketing affiliate program online when you join genuine affiliate marketing training resource