MySQL script for exporting rows to a flat file

I need a script that will export data from a MySql database into flat files and into a folder structure. The script would need to strip out all non-allowable characters (for Windows) in the file name.

The solution could run inside MySQL or outside, but must run on a Windows Vista machine.

The database is composed of several tables. There are article tables for each category (for instance, "Legal"), and then a table listing all of the sub-categories (Legal:Living-Will) that are in all of the categories tables.

The current database structure looks like this, with sample data in the parentheses () and any columns to be excluded marked "do not use":


-ID (1)

-Category (Legal:Living-Will)

-Author (do not use)

-Title (Free Last Will And Testament Packages)

-articletext (blob)

-keywords (do not use)


-ID (1)

-Category (Legal:Living-Will) (Legal)

The text file structure would need to look like:

-Table (folder)

--Living Will (folder)

----Free Last Will And Testament [url removed, login to view]

However, some of the articles do not have a sub-category, and instead fall under the larger category (Legal).

There are 12 category tables that would need to be exported. I can provide a full list once the job is accepted.

The total database is too large to export, so I have included a sample of the data.

The following are included as non-acceptable Windows filename characters:

* Asterisk

< >[ ] Brackets

= Equal sign

+ Plus sign

" Quotes

\ / Slashes

, . : ; Comma, Period, Colon, Semicolon

## Deliverables

Will need developer to provide any support needed to get the script running if special requirements (install of anything) are needed.

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software

Veja mais: sample job listing, requirements needed for engineering, name of any article author, mysql developer job, mysql database for free, look for script developer, data structure solution, asterisk sign, structure engineering, semicolon, rows, i need a developer for free, export mysql, keywords article php mysql, windows sign file, mysql characters, php support mysql, mysql flat file, mysql structure, flat php, export mysql data txt, php script mysql export, php brackets, php flat, php export text file

Acerca do Empregador:
( 7 comentários ) United States

ID do Projeto: #3013697

Concedido a:


See private message.

$50.15 USD em 14 dias
(396 Comentários)

2 freelancers are bidding on average $51 for this job


See private message.

$51 USD in 14 dias
(0 Comentários)