Convert-DB: PHP Script To Import Csv Data Into Mysql…
- December 31st, 2011
- Write comment
Introduction:
Our resources are simple yet powerful enough to transfer and move information between many common data bank and CSV / Delimited Text information files and Set Size information files. Current edition 3.6 can handle MySQL, Oracle, MS Access, FoxPro, DBF’s, MS SQL Hosting server, Shine, CSV and Delimited or Flat Files. You can use our resources to turn information from one information source structure to another information source structure. While switching you can narrow content, map source desk content to target desk content and also specify WHERE conditions to narrow lines.
Explanation:
This is a easy program that will allow you to transfer csv information into your data source. This comes useful because you can merely modify the appropriate job areas, publish it along with the csv submit and contact it from the web and it will do the relax.
It allows you to specify the delimiter in this csv submit,
Links MSSQL to MySQL whether it is a coma, a tab etc. It also allows you to select the range separator, allows you to spend less the result to a submit (known as a information sql dump).
It also lets you to involve an clear area at the starting of each row, which is usually an automatic rise integer major key.
This program is useful mainly if you do not have php myadmin, or you do not want the stress of signing in and desire a few important option, or you merely are a control fast guy.
Just create sure the desk is already designed before trying to dispose of the information.
Kindly publish your feedback if you got any bug review.
Whenever you update your MySQL set up, create sure to update any customer that uses it.
In some situations, customers that use a edition before 4.1 will have a issue authenticating against the MySQL data source if the latter has a publish 4.1 edition.
The technique is that after 4.1 (i.e. 4.11 and up), MySQL improved the way it shops the accounts in the customer desk in the mysql program data source.
Password hashes are now 41 bytes extensive instead of the old 16 bytes.
So for example, if your MySQL hosting server is 5.0, while your php-mysql archives is 4.1, your web programs will fall short to go to the data source. As such, it is suggested that you update the consumer.
In any situation, MySQL provides a way to modify the hash rear into the old structure. For the benefit of disagreement, believe the customer in concern is bob, and you want to be able to be connected using code phony. In this situation,
Links CSV to MySQL go to your MySQL hosting server from the fast (SSH and use ‘mysql -u main -p mysql’ on unix like, or go to your mysql/bin windows index and do the same query), then concern the following queries:
Some Of The Features:
Supports UPSERT and INSERT loading options.
Imports Constraints and Indexes
Wizard based
Support for MS-Access 2007 and and MS-SQL Server Express Edition.
Now watch progress while running saved sessions
Map Source Columns to Target Table columns or Skip chosen columns
Load from multiple delimited flat files to multiple tables in one session
Save and Schedule of Sessions for recurring data transfers.
Fast Speed
Completely user friendly
No need to write any code
Select single or multiple tables to transfer
Select or Deselect Columns while transferring
Change Destination Datatypes and widths
Automatic Checking of Datatype mismatch
Specify WHERE conditions to filter data
Economical costs just $99
Find helpful knowledge in the sphere of – make sure to go through the publication. The time has come when proper info is truly at your fingertips, use this opportunity.