Find Jobs
Hire Freelancers

37553 MySQL Database Consolidattion

N/A

Igangværende
Slået op cirka 18 år siden

N/A

Betales ved levering
I have 2 databases for the same product that have been used for different web sites. I need to consolidate them into 1 database. The problem is, that the 2 databases have duplicate customer numbers and order numbers - so I need to take the smaller one and I suppose find a way to re-number the orders and customer numbers so that all customers can access their accounts from the same database. I am thinking that perhaps the best way to accomplish this is to rename each of the customer account numbers and order numbers in the database that will be deleted, maybe by simply adding an additional character to the end of the account numbers and order numbers, but whatever you think will work best will be fine. I just want to make sure that no data is lost and that customers will still be able to log into their accounts using the same username and password. Additionally, you will note that in the databases there are product numbers and descriptions. I want to keep the product numbers and descriptions in the database 'jeffreyc_svpro'. In order to do this and make sure that all of the customers in database 'subliminal-mind' can still access their correct downloads there will likely need to be some manual re-numbering first of the product codes/descriptions in database 'subliminal-mind' in both the product section and in the section associated with the customers' particular orders to correspond to the product codes/descriptions located in the database 'jeffreyc_svpro'. Please be sure before making any changes that you backup both databases. The fist database is located here (this is the database that I would like to be made the FINAL and COMPLETE database, because it is the largest - it is called jeffreyc_svpro: Server: [login to view URL] User: root Password: ch4mb3rs DirectAdmin: [login to view URL] username: admin pass: EnNEIa7E To access phpmyadmin, you can go through DirectAdmin. On the main page, click on 'Show All Users', then click on 'jeffreyc' link. Then you can click on 'Login as jeffreyc'. Next, click on 'MySQL Databases' and then you can click on 'phpMyAdmin' link. If you are not logged in automatically, the login using: login: jeffreyc pass: jeffnow1 Or directly: [login to view URL] login: jeffreyc pass: jeffnow1 The second database, which I wish to be moved into the database above is located here and is called "subliminal-mind": Server: [login to view URL] User: root Password: caldirect DirectAdmin: [login to view URL] username: admin pass: jc66dv75 To access phpmyadmin, you can go through DirectAdmin. On the main page, click on 'Show All Users', then click on 'subliminal' link. Then you can click on 'Login as subliminal'. Next, click on 'MySQL Databases' and then you can click on 'phpMyAdmin' link. If you are not logged in automatically, then login using: login: root pass: 8aSmRdym Or directly: [login to view URL] login: root pass: 8aSmRdym
Projekt-ID: 1787156

Om projektet

1 forslag
Projekt på afstand
Aktiv 12 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
As discussed in PMB
$60 USD på 2 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for
5,0
8
Medlem siden jan. 1, 2005

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.