SEO Tips - SEO Blog - Internet Marketing - Search Engine Optimization

» MySQL

  • MYSQL Dump/Restore
    By on May 6th, 2009 | 4 Comments4 Comments Comments
    MYSQL Dump/Restore
    MySQL Dump/Restore Dump ALL MySQL Databases : mysqldump –user=XXXXXXXX –password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL Dump Individual or Multiple MySQL Databases : mysqldump –user=XXXXXXXX –password=XXXXXXX DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL Dump only certain tables from a MySQL Database : mysqldump –user=XXXXXXXX –password=XXXXXXXX DB_NAME –tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL I’m using MySQL 4.1.8 on my development server, but am behind a few releases on our production server. In order to make dumps compatible with t...
  • [PHP] Manipulating MySQL (an introduction)
    By on January 14th, 2009 | No Comments Comments
    [PHP] Manipulating MySQL (an introduction)
    this article is meant for users that have little/no knowledge of how to manipulate MySQL databases via PHP code. Intermediate users might find this useful brush up reading. the first thing you need to learn is how to open a connection with the MySQL server. this is achieved by PHP’s built in function, mysql_connect();Code: resource mysql_connect ( [string server [, string username [, string password]]] )as you can see, the mysql_connect(); function processes 5 parameters when it is accessed. the string server is the MySQL server, on most webhosts and home rigs, this will be localhost...
  • How-To: Create A Common MySQL Connect File
    By on January 13th, 2009 | 1 Comment1 Comment Comments
    How-To: Create A Common MySQL Connect File
    On just about every domain I own, or for every client I do a job for, there’s some interaction with MySQL and PHP. Here’s a good “common database” file to use. I call mine common.inc and use it as an include for every page, but of course you can other other information into your common file, which is always a good thing to have. PHP Code: // Database Variables $dbhost = "localhost"; $dbuser = "username"; $dbpass = "password"; $dbname = "database"; $MYSQL_ERRNO = ""; $MYSQL_ERROR = ""; // Connect To Database function db_connect() { global $dbhost, $dbuser, $dbpass, $db...
  • Setting up MySQL
    By on January 13th, 2009 | 1 Comment1 Comment Comments
    Setting up MySQL
    Installation The MySQL installation is pretty straightforward since you doesn’t need to modify anything in the Apache or PHP configuration. To begin the installation, run the setup program and select the destination folder if you don’t want to use the default one. Then choose Custom and deselect Examples, Libraries, Includes and Script files. You can deselect also the MySQL Documentation if you already have it.Press Next for starting the installation. After it finish, you need to install the MySQL service, since the setup program of versions 4.0.x doesn’t install it. Fortun...
  • Backup a database using phpMyadmin
    By on January 13th, 2009 | 2 Comments2 Comments Comments
    Backup a database using phpMyadmin
    Backup of Mysql database It is assumed that you have phpMyAdmin installed since a lot of web service providers use it. 0. Open phpMyAdmin. 1. Click Export in the Menu to get to where you can backup you MySql database. Image showing the export menu. 2. Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name. 3. Select”SQL”-> for output format, Check “Structure” and “Add AUTO_INCREMENT” value. Check “Enclose table and field name wit...
  • Backing Up and Restoring Your Database with PHPMyAdmi...
    By on January 7th, 2009 | 1 Comment1 Comment Comments
    Backing Up and Restoring Your Database with PHPMyAdmin
    You can backup your database using PHPMyAdmin in just a few mouse clicks. First head over to your database by clicking the database name in the list on the left of the screen. Once you get to your database details, you should get a menu header for your database which looks like so:Click on Export. This will get you to a screen with the following options.From here it’s just a matter of clicking the right options and the ‘Go’ Button to get your database dump. To save the backup file on your computer, click on the Save as file option and the corresponding compression option ...
  • Backing Up and Restoring Your MySQL Database
    By on January 7th, 2009 | 2 Comments2 Comments Comments
    Backing Up and Restoring Your MySQL Database
    Do youneed to change your web host or switch your database server? This is probably the only timewhen you really think of backing up your MySQL data. If you’ve got a website with a database or your custom database running for your applications, it is imperative that you make regular backups of the database. In this article, Iwill outline two easy ways of backing up and restoring databases in MySQL. The easiest way to backup your database would be to telnet to the your database server machine and use the mysqldump command to dump your whole database to a backup file. If you do not have te...