Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> Copy Databases In phpMyAdmin
96than
post Nov 9 2006, 10:37 PM
Post #1


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 22
Joined: 2-October 06
From: Norway
Member No.: 16,297



i have just got hosting here on astahost and i have to copy my databases from my old server...
is there an easy way of doing this? in phpmyadmin?
thanx in advance you know lol wink.gif
Go to the top of the page
 
+Quote Post
TavoxPeru
post Nov 10 2006, 05:03 AM
Post #2


Super Member
Group Icon

Group: [HOSTED]
Posts: 750
Joined: 8-April 06
From: Lima - Peru
Member No.: 12,579



QUOTE(96than @ Nov 9 2006, 05:37 PM) *

i have just got hosting here on astahost and i have to copy my databases from my old server...
is there an easy way of doing this? in phpmyadmin?
thanx in advance you know lol wink.gif

Yes, you can do this with phpmyadmin, you can do it with the import option if you first export your database as a sql file, take care with your databases charsets and versions, you can found some trouble with it.

Best regards,

Go to the top of the page
 
+Quote Post
jlhaslip
post Nov 10 2006, 05:08 AM
Post #3


Advanced Member
Group Icon

Group: Members
Posts: 185
Joined: 15-November 05
From: Inland from the Left Coast of Canada
Member No.: 9,627



Phpadmin would work, yes.

Export the database structure and content from the source and then Import it into the Target at the new location. You might also consider that the structure and data could be Exported / Imported seperately. That would let you define the databases first before adding the data.

I might suggest you do a test run, set up the database and site at the new location before you actually delete anything at the original location. smile.gif *stuff happens* smile.gif

If you need any further direction, post back here and somone will assist you.
Go to the top of the page
 
+Quote Post
96than
post Nov 10 2006, 09:50 AM
Post #4


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 22
Joined: 2-October 06
From: Norway
Member No.: 16,297



thanx guys smile.gif
i didnt know it was that easy lol
i have moved the databases now and its all working smile.gif
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. The Best Database(41)
  2. Need Advice On Creating Online Music Database(6)
  3. Hosting A Server On Database(6)
  4. phpMyAdmin-MySQL Error #1251:client Authentication(6)
  5. Migrating Databases(2)
  6. Creating Databases(4)
  7. Unexpected Database Crashes(0)
  8. Combining Databases(4)
  9. Updating A Database's Tables(10)
  10. How To Use MySQL/phpMyAdmin Under Linux(5)
  11. What Is A Database How Do I Use One?(7)
  12. How To Setup SMF Databases?(4)
  13. Can You Make Your Own MySQL Databases?(7)
  14. Ms Databases(6)
  15. How Do You Make Large Databases?(14)
  1. Examining Databases At A Whole Glance(7)
  2. Phpmyadmin Export And Collation Problems(4)
  3. All About Databases(3)
  4. Free Graphical Tools For Databases(7)
  5. Databases(2)


 



- Lo-Fi Version Time is now: 8th September 2008 - 06:21 AM