Not sure if I am in the right category to ask this question but here goes.
I need to create a database for my site where I can export all the info and feed into a new database which will give loads of info like total sales, break down into months, weeks etc to look at trends, patterns, location of buyers etc etc. All way above my head by the way, my other half will be doing all of this.

Anyway he uses sql at work but has never tried to extract from mysql.Do you know of any software out there that can extract from mysql.

If so is it free, or what is the cost of it?

Hope i have explained this correctly. In a nutshell he wants to be able to extract data from the mysql database to feed into a new database to give more info etc. at te push of a button

Blush

__________________

Childrens Fancy Dress Costumes and Fairtrade Clothes
Childrens Costumes and Dancewear

When you back up your database that's exactly what you are doing.

You can use phpMyAdmin to export selected tables as SQL or CSV files, MySQL is just a database engine where as SQL is the language used, though there are some differences between the SQL used on MySQL and standardised SQL but this shouldn't be an issue for what you want to do with it

Just export the tables you want then import them into your hubby's application.I can't see there being any problems and if there is a slight incompatibility issue then it will only be a simple matter to fix but it's unlikely.

You can have he whole process automated if you'd rather not use phpMySQL with a script, though I can't name an exiting one off the top of my head but there are plenty out there.

So either export the required tables as SQL and import them directly into the other database or export them as a CSV file and get your hubby to write a script to import it into the other database in the format he needs.

Either way, what he wants to do is an easy process.

__________________
Lawrence

Thanks for that

__________________

Childrens Fancy Dress Costumes and Fairtrade Clothes
Childrens Costumes and Dancewear