creating mysql file, help!

NetworkTown.Net · 10-15-2006, 02:39 AM

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:

PHP Code:

  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 · 10-15-2006, 02:53 AM

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

NetworkTown.Net · 10-15-2006, 03:02 AM

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

Joe · 10-15-2006, 03:11 AM

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 · 10-15-2006, 03:38 AM

Quote:

Originally Posted by TheArbiter

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 · 10-15-2006, 11:11 AM

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 · 10-15-2006, 06:34 PM

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

10-15-2006, 02:39 AM	#1 (permalink)
NetworkTown.Net Account Closed Join Date: Oct 2005 Location: United Kingdom Posts: 1,554 55.39 NP$ (Donate)	creating mysql file, help! 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: PHP Code: 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.

10-15-2006, 02:53 AM	#2 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	Make a script that does it for you, or use phpMyAdmin __________________ Website \| Blog \| Uzbl (my branch) 9thSeptember2009.com

10-15-2006, 03:11 AM	#4 (permalink)
Joe Senior Member Join Date: Oct 2005 Location: Kent ~ U.K. Posts: 3,246 88.85 NP$ (Donate)	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 __________________ Fused Hosting Simplicity and Superiority. █████████████████████████████████████████████ Affordable web hosting solutions; shared, reseller, shoutcast, WHMSonic, proxy, dedicated and more! My computer is broken; new components have been ordered.

10-15-2006, 03:02 AM	#3 (permalink)
NetworkTown.Net Account Closed Join Date: Oct 2005 Location: United Kingdom Posts: 1,554 55.39 NP$ (Donate)	do you have any links or a keyword that i can seacrh for so then i know what im looking for.

10-15-2006, 11:11 AM	#6 (permalink)
NetworkTown.Net Account Closed Join Date: Oct 2005 Location: United Kingdom Posts: 1,554 55.39 NP$ (Donate)	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.

10-15-2006, 06:34 PM	#7 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	Just export it and delete the AUTO INCREMENT stuff. That will mess up their database if they try to do anything, though.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)