|
While I was programming some scripts for this website I encountered a very big problem - I could not import very big database files into my phpMyAdmin.
There are many different solutions to this problem, of which this software that I have writen is one of them.
With this software you can do the following:
- Convert CSV files to SQL files,
- Split up the SQL file into smaller files with a specified number of rows,
- Convert Unix linefeed into Windows type
- Specifie whether or not field names are requested.
One problem with phpMyAdmin is that very big database files can not be imported. This limitation is set by the webserver host. In my case it is 120 seconds. This can be solved by either splitting the SQL file up in smaller files, using my software, or using a different upload procedure.
The php script file and the SQL database file must both be place at the same path on the same server. |
