[advanced search]
 

Go Back   NamePros.com > Discussion > Web Design & Development > Programming

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.


Closed Thread
 
LinkBack Thread Tools
Old 10-15-2006, 02:39 AM   #1 (permalink)
Account Closed
 
Join Date: Oct 2005
Location: United Kingdom
Posts: 1,554
55.39 NP$ (Donate)

NetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really nice


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.
NetworkTown.Net is offline  
Old 10-15-2006, 02:53 AM   #2 (permalink)
Barru.
 
Barrucadu's Avatar
 
Join Date: Aug 2005
Location: East Yorkshire, England
Posts: 2,731
78.50 NP$ (Donate)

Barrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to behold


Make a script that does it for you, or use phpMyAdmin
Barrucadu is offline  
Old 10-15-2006, 03:02 AM   #3 (permalink)
Account Closed
 
Join Date: Oct 2005
Location: United Kingdom
Posts: 1,554
55.39 NP$ (Donate)

NetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really nice


do you have any links or a keyword that i can seacrh for so then i know what im looking for.
NetworkTown.Net is offline  
Old 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)

Joe has much to be proud ofJoe has much to be proud ofJoe has much to be proud ofJoe has much to be proud ofJoe has much to be proud ofJoe has much to be proud ofJoe has much to be proud ofJoe has much to be proud ofJoe has much to be proud ofJoe has much to be proud of

Save The Children Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009
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
Joe is offline  
Old 10-15-2006, 03:38 AM   #5 (permalink)
Account Closed
 
Join Date: Oct 2005
Location: United Kingdom
Posts: 1,554
55.39 NP$ (Donate)

NetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really nice


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

NetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really niceNetworkTown.Net is just really nice


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.
NetworkTown.Net is offline  
Old 10-15-2006, 06:34 PM   #7 (permalink)
Dan
Buy my domains.
 
Dan's Avatar
 
Join Date: Feb 2006
Posts: 2,801
56.00 NP$ (Donate)

Dan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant futureDan has a brilliant future

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


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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Site Sponsors
Advertise your business at NamePros

All times are GMT -7. The time now is 07:44 PM.


Powered by: vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Template-Modifications by TMS
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85