corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » MYSQL Database


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author MYSQL Database
liamC
Member

Registered: 28th Feb 04
User status: Offline
18th Dec 06 at 15:36   View User's Profile U2U Member Reply With Quote

Right, basically I am doing a PHP/MYSQL website for a new and used car company for my Uni project.

The company currently has a website which has a database of cars of what they have available on it, but the website is complete crap, so I am starting from scratch with a new design etc, but then the intention is to import that database in to the website's design.

Will it be (relatively) straight forward to import that database into the new site or not?
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
18th Dec 06 at 16:07   View User's Profile U2U Member Reply With Quote

Providing you keep the table structures the same, yes it will be very easy.
PaulW
Member

Registered: 26th Jan 03
Location: Atherton, Greater Manchester
User status: Offline
18th Dec 06 at 16:48   View User's Profile U2U Member Reply With Quote

is the original database in access??

whatever its in, really you can just export what you need to a csv file, and then straight into the mysql database with a little script, and just go from there!

as james said, aslong as the structure is there, its pretty simple!
AndyKent
Member

Registered: 3rd Sep 05
User status: Offline
18th Dec 06 at 17:57   View User's Profile U2U Member Reply With Quote

if its hosted on the same server you won't need to change the database - just design the site and have it pull data from the existing one....saves all the messing about

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Linking .jsp pages to a MySQL database chris_lee100 Geek Day 7 1433
1st Feb 04 at 14:23
by Ian
 
forum hacking - SQL's Drew Geek Day 15 1720
9th Sep 04 at 23:50
by Ian
 
Server Help Jodi_the_g Geek Day 7 1458
19th Jan 06 at 15:18
by Jodi_the_g
 
New Website People weerab General Chat 9 888
13th Aug 06 at 21:19
by weerab
 

Corsa Sport » Message Board » Off Day » Geek Day » MYSQL Database 29 database queries in 0.0101640 seconds