020 555 1111
  • Old fashion, modular, procedural PHP plus some scaffolding techniques to allow it to mimic MVC simplicity.
  • A quick reference to help you find in PHP maze what needs to be done and how to do it.
  • Learn a PHP Object Oriented Programming by building a live discussion forum application.
  • MVC - Model View Controller - real life, easy reference and application.
This product has options, take a look at them and select ones you like the most.
Options are displayed under image section.

uploading/exporting large databases
[examples]

How to upload large(r) databases

HOW TO: import table, database, make a dump etc.

see: this link

load data into tables from delimited files

  1. log in to mysql command line utility (mysql>)
    1. you can di it directly, e.g. from WAMP tray, etc.
    2. you can use shell, e.g. via. Putty, just call a mysql.exe file, like:
      C:\wamp\bin\mysql\mysql5.5.20\bin\mysql.exe
      where: C:\wamp\bin\mysql\mysql5.5.20\bin\ should be a dir to your mysql.exe location
  2. use LOAD DATA INFILE - something like this
    LOAD DATA INFILE '[path/to/file.txt]' INTO TABLE [db.table_name] CHARACTER SET 'utf8' FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' IGNORE 1 LINES \g
    
    example:
    LOAD DATA INFILE 'C:\\Users\\jeffz\\Desktop\\ean_db_relational\\ActivePropertyList.txt' IGNORE INTO TABLE hmvc.ean_active_property_list CHARACTER SET 'utf8' FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 LINES \g
    LOAD DATA INFILE 'C:\\Users\\jeffz\\Desktop\\ean_imps\\Blockbusters.csv' IGNORE INTO TABLE hmvc.ean_airports CHARACTER SET 'utf8' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES \g
    LOAD DATA INFILE 'C:\\Users\\jeffz\\Desktop\\ean_imps\\Blockbusters.csv' IGNORE INTO TABLE hmvc.ean_dealsx CHARACTER SET 'utf8' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES \g
    LOAD DATA INFILE 'C:\\Users\\jeffz\\Desktop\\ean_db_relational\\RegionEANHotelIDMapping.txt' IGNORE INTO TABLE hmvc.ean_coords_p2r CHARACTER SET 'utf8' FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 LINES \g
    
    info: 
     IGNORE 1 LINES - ignore top title line

 

load mysql directly from putty (shell) 

My experience with mysql command line utility is very mixed.

Most of the time I cannot make it work, so I suggest Putty for server and win command prompt for WAMP

  1. go to location of your mysql command line utility (mysql.exe)
    cd C:\wamp\bin\mysql\mysql5.5.20\bin
    
    note: change "C:\wamp\bin\mysql\mysql5.5.20\bin" to your actual location
  2. exporting (DUMP)
    mysqldump -u root -p exportedDB > C:\\Users\\jeffz\\Desktop\\yourDBdump.sql
  3. importing (upload) of large database
    mysql -u root -p targetDB < C:\\Users\\jeffz\\Desktop\\uploadedDB.sql

 

upload zipped database, unzip and install to sql server

  1. upload zipped mysql DB file to main, topmost site folder
  2. unzip zipped DB - use shell command
    unzip mysql_zipped_file.zip
  3. create database using phpMyAdmin/DirectAdminCpanel (etc.), or use existing database
  4. install mysql database (no space between -p and password)
    mysql -u root -pyourDBpass targetDB < unzipperDB.sql