WorldWideScripts.net Delivering the best Add-Ons in more than 37 languages.

中文(简体), English, हिन्दी/हिंदी, Español/Castellano, العربية, Русский язык, Français, 中文 (台灣), বাংলা, Bahasa Indonesia, اردو, Português, Deutsch, Bahasa Melayu (بهاس ملايو‎), 日本語 (にほんご), فارسی, Italiano, తెలుగు, Türkçe, ગુજરાતી, Język polski/polszczyzna, Tiếng Việt, ಕನ್ನಡ, Українська мова, ไทย
PHP Scripts / Database Abstractions

Advanced Mysql Exporter/Importer

— Add-On to WorldWideScripts.net

Subscribe to our feed to stay up to date!

New! Follow us as you want it!


Advanced Mysql Exporter/Importer - CodeCanyon Item for Sale

Ads

Ad: Bluehost hosting

Advanced Mysql Exporter/Importer


Advanced Mysql Exporter/Importer is a simple web application allow users to export or import any tables from or to CSV, Excel, PDF files.
No special installation needed, the admin Login/Password is stored in configuration file and protected with.htaccess file

Advanced Mysql Exporter/Importer able to :
  • Export Import CSV
  • Export Import Excel (xlsx, xls), Export PDF
  • Export to CSV, Excel and PDF with custom queries
  • Enable update queries
  • Console command line to export/import huge databases
Advanced Mysql Exporter/Importer using :
  • Bootstrap style + reponsive version
  • Simple MCV Application
  • Easy Installation

You can customise the import or export function to be applied for each recored, you don’t want to use it put them to `none`.
By default they are in config/parameters.ini :
export_encode_function=”utf8_encode”
import_encode_function=”utf8_decode”

For some databases, you need to setup the option database_default_charset in config/parameters.yml, example : `database_default_charset: “utf8”`

Requires

  • PHP 5.x
  • Mod_rewrite enabled
  • Enable the.htaccess rewrites in your vhost
     DocumentRoot /var/www/project <Directory /var/www/project> AllowOverride All Order allow,deny Allow from All </Directory> 

Installation

This is the 2.0 version.
  • Put the whole application where you want
  • Change the admin login/password in config/parameters.yml
  • Change the url in config/parameters.yml
  • Enjoy!

Console Commande

  • To import huge databases open file config/console.yml, in import settings section configure table name and import options, next just run : `php bin/console import`
  • To export huge databases open file config/console.yml, in export settings section configure table name and export options, next just run : `php bin/console export`
  • Enjoy!
Update : Version 2.0 :
  • Command line to export/import huge databases
  • Enable update queries
  • Using yml files for application configuration instead of ini
  • Add database_default_charset option in parameters.yml
  • Improve performances
  • Fix minor bugs
Update : Version 1.1 :
  • Fix minor bugs
  • Allowing execution with previous version of PHP 5 (like PHP 5.2)

Advanced Mysql Exporter/Importer need PHP5 to work.
Live Demo
If you like this script please take a minute and rate it :)


Download
Other components in this categoryAll components of this author
CommentsFrequently asked questions and answers

Properties

Created:
7 December 12

Last Update:
15 March 13

Files Included:
JavaScript JS, HTML, CSS, PHP

Software Version:
PHP 5.x, PHP 5.0 - 5.2, PHP 5.3, PHP 5.4, PHP 5.5, MySQL 4.x, MySQL 5.x

Keywords

eCommerce, All Items, Export Mysql, command php, console, csv, database abstractions, export CSV, export PDF, export excel, huge database, import excel, import mysql