New Posts  All Forums:Forum Nav:

moving sql database

post #1 of 6
Thread Starter 
so i currently pay $5 a month for hosting for a site i run. last night i built a small server and hopefully will be setting it up soon so that it can be accessed from anywhere (outside router). i want to move my hosting from the pay sites server to my server so that i don'thave to pay for hosting anymore. what is the best way to move the whole database over so that to the end user it appears seemless.
Bravo
(13 items)
 
  
CPUMotherboardGraphicsRAM
X4 955 @ 3.6 Asus M479T 4870 1GB 8 GB DDR3 
Hard DriveOSPowerCase
160 GB Win 7 Antec 750w Antec 300 
  hide details  
Reply
Bravo
(13 items)
 
  
CPUMotherboardGraphicsRAM
X4 955 @ 3.6 Asus M479T 4870 1GB 8 GB DDR3 
Hard DriveOSPowerCase
160 GB Win 7 Antec 750w Antec 300 
  hide details  
Reply
post #2 of 6
What type of database are you using? Easiest thing, methinks, is to take the site down temporarily, backup the database, copy it from pay site to your server, restore the backup, and attach the database back. Then just bring your site back up and running. Barring any strange and unforeseen circumstances, you shouldn't be down for more than thirty minutes to an hour, depending on the size of your db.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
i5 3570K Asrock Z77 Gigabyte 6850 G.Skill F3-12800CL9 
Hard DriveOptical DriveOSMonitor
WD Caviar Black Asus 24x DVD-RW Multi Win 7, CentOS, BT 5.0 RC2, Mac OSX 10.7.4 Dual Asus VH236H 
KeyboardPowerCaseMouse
Saitek Eclipse PC P&C 610 KingWin Logitech Optical TracBall 
Mouse Pad
A drug company generic black pad 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
i5 3570K Asrock Z77 Gigabyte 6850 G.Skill F3-12800CL9 
Hard DriveOptical DriveOSMonitor
WD Caviar Black Asus 24x DVD-RW Multi Win 7, CentOS, BT 5.0 RC2, Mac OSX 10.7.4 Dual Asus VH236H 
KeyboardPowerCaseMouse
Saitek Eclipse PC P&C 610 KingWin Logitech Optical TracBall 
Mouse Pad
A drug company generic black pad 
  hide details  
Reply
post #3 of 6
you will have to have your site down for a short period of time no matter what happens. you will have to detach the database (the down time) back it up and then reattach it.

Then once you get the backup onto your sever and restored, make sure everything is working properly then you will have to change the NS records in your DNS zone to point to your server. It will take about a day for all the DNS servers switch to the new server.
post #4 of 6
Thread Starter 
haveing some downtime is expected and ok. the database is pretty small, just a forum and site with about 30 users. i will try that out when it comes time. thanks.
Bravo
(13 items)
 
  
CPUMotherboardGraphicsRAM
X4 955 @ 3.6 Asus M479T 4870 1GB 8 GB DDR3 
Hard DriveOSPowerCase
160 GB Win 7 Antec 750w Antec 300 
  hide details  
Reply
Bravo
(13 items)
 
  
CPUMotherboardGraphicsRAM
X4 955 @ 3.6 Asus M479T 4870 1GB 8 GB DDR3 
Hard DriveOSPowerCase
160 GB Win 7 Antec 750w Antec 300 
  hide details  
Reply
post #5 of 6
Im pretty sure in phpmyadmin, theres an export feature. that should act as a backup.

export it> then theres an import feature.
Serenity
(10 items)
 
  
CPUMotherboardGraphicsRAM
AMD Athlon X4 860K Gigabyte GA-F2A88X-UP4 MSI R9 270X GAMING 2G HyperX Savage 8GB (2 x 4GB) DDR3 2400 
Hard DriveCoolingOSPower
AMD Radeon SSD RADEON-R7SSD-120G ZALMAN CNPS9900MAX-R Windows 7 64-bit EVGA 500 Watt 80+ 500 Watt (Silver) 
CaseAudio
Corsair Graphite Series 230T Orange Soundblaster X-Fi Titanium 
  hide details  
Reply
Serenity
(10 items)
 
  
CPUMotherboardGraphicsRAM
AMD Athlon X4 860K Gigabyte GA-F2A88X-UP4 MSI R9 270X GAMING 2G HyperX Savage 8GB (2 x 4GB) DDR3 2400 
Hard DriveCoolingOSPower
AMD Radeon SSD RADEON-R7SSD-120G ZALMAN CNPS9900MAX-R Windows 7 64-bit EVGA 500 Watt 80+ 500 Watt (Silver) 
CaseAudio
Corsair Graphite Series 230T Orange Soundblaster X-Fi Titanium 
  hide details  
Reply
post #6 of 6
Thread Starter 
yeah, i'll look for that. thanks everyone
Bravo
(13 items)
 
  
CPUMotherboardGraphicsRAM
X4 955 @ 3.6 Asus M479T 4870 1GB 8 GB DDR3 
Hard DriveOSPowerCase
160 GB Win 7 Antec 750w Antec 300 
  hide details  
Reply
Bravo
(13 items)
 
  
CPUMotherboardGraphicsRAM
X4 955 @ 3.6 Asus M479T 4870 1GB 8 GB DDR3 
Hard DriveOSPowerCase
160 GB Win 7 Antec 750w Antec 300 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming