creating mysql file, help!

NetworkTown.Net · 10-15-2006, 03: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!'); 

????: NamePros.com http://www.namepros.com/programming/247421-creating-mysql-file-help.html

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, 03:53 AM

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

NetworkTown.Net · 10-15-2006, 04: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, 04: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, 04:38 AM

Originally Posted by TheArbiter

if you use cpanel
????: NamePros.com http://www.namepros.com/showthread.php?t=247421
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, 12:11 PM

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, 07: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, 03:39 AM	THREAD STARTER #1 (permalink)
NetworkTown.Net Account Closed Join Date: Oct 2005 Location: United Kingdom Posts: 1,554	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!'); ????: NamePros.com http://www.namepros.com/programming/247421-creating-mysql-file-help.html 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, 03:53 AM	#2 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Make a script that does it for you, or use phpMyAdmin __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-15-2006, 04:11 AM	#4 (permalink)
Joe Senior Member Join Date: Oct 2005 Location: Kent ~ U.K. Posts: 3,209	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 __________________ Myself and "JackHeskett" are no longer associated with FusedHosting.net. Please pipe all PMs to admin [at] fusedhosting.net.

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

10-15-2006, 12:11 PM	THREAD STARTER #6 (permalink)
NetworkTown.Net Account Closed Join Date: Oct 2005 Location: United Kingdom Posts: 1,554	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, 07:34 PM	#7 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	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)