Creating mysql file, help!

[NetworkTown.Net]

Hi

I have a DB of content around 1500 content in one table, i need to know how i can export it so when i give it to my users they can run it in mysql and it will add it to there db, since export function is useless it dose not export they way i need it, i need it so it is runable for all users. i.e i need it like this:

INSERT INTO `games` ( `gId` , `gInCategory` , `gSwfFile` , `gName` , `gOrder` , `gVisible` , `gThumb` , `gWidth` , `gHeight` , `gDescription` ) VALUES ('', 1, 'pacman2.swf', 'Pacman', 0, 1, 'pacman.jpg', '320', '340', 'As you know it, Pacman!');

i need it like that, how do the big companys do it? like GS, GSS, whmcs ect how do they create the sql im sure they dont go thou every thing and type it out there is a quick way to do it, but i dont know how im sure one of you will know.

 

[Barrucadu]

Make a script that does it for you, or use phpMyAdmin

 

[NetworkTown.Net]

do you have any links or a keyword that i can seacrh for so then i know what im looking for.

 

[Joe]

if you use cpanel
go to the mysql page
go to the bottom and click on phpMyAdmin
then, from the dropdown on the left, select your database

now you can create/modify/delete and also add rows

Joe

 

[NetworkTown.Net]

if you use cpanel
go to the mysql page
go to the bottom and click on phpMyAdmin
then, from the dropdown on the left, select your database

now you can create/modify/delete and also add rows

Joe

I dont think you understood, i know how to use phpmyadmin, i need to create the sql for my db so other users can use it when i do export it dont work since some rows have auto-incresment.

 

[NetworkTown.Net]

ok look basicly i need to know how to export my db without the auto-increasment numbers. but i need '' to be there in stead of it.

 

[Dan]

Just export it and delete the AUTO INCREMENT stuff. That will mess up their database if they try to do anything, though.