Results 1 to 7 of 7

Thread: Restore MySQL db to different domain

  1. #1
    Join Date
    Feb 2003
    Location
    Kluang, Johor
    Posts
    2,367
    Rep Power
    250

    Restore MySQL db to different domain

    Hi,

    I have backup a mysql database using phpmyadmin at DomainA.com. the database name is DomainA_DomainA

    I want to restore it to another DomainB.com, the database name is DomainB_DomainB.

    When I login DomainB.com and restore using phpmyadmin, I got a lot of errors. Seems like due to the wrong database name.

    How do you solve this problem?
    What are your solutions please?

    For me, I will manually search all DomainA_DomainA in backup database file(since it is text based) and replace with DomainB_DomainB. Is this correct way?

    Thank you in advance.

    Addition:
    I tried Cpanel backup database restore, but it gives me some weird error - asked me to download/open ['] file, whole page become black and with table...
    Last edited by lcf; 01-02-2004 at 11:32 AM.

  2. #2
    Join Date
    Apr 2002
    Location
    Cyberspace
    Posts
    492
    Rep Power
    223
    if u make a backup from cpanel..

    try to dump it manually via phpmyadmin

    open ur sql backup file..

    delete/correct every syntac that are not for mysql

    save the file as any.sql then dump it usin phpmyadmin or ssh

    if u using phpmyadmin then... there should be no dbname involved because u 're already created the db name

    hope u understand what im trying to say or maybe get some idea with the xplanation

    on new domain:
    create new db
    assign new user
    open the phpmyadmin
    dump the corrected file

    thats all

    got no time to xplain more.. hari raya
    Domain Registration = RM35/Year com net org biz info us

  3. #3
    Join Date
    Feb 2003
    Location
    Kluang, Johor
    Posts
    2,367
    Rep Power
    250
    yup. Dump the sql database after post the message.
    thank you anyway

  4. #4
    Join Date
    Apr 2002
    Location
    Cyberspace
    Posts
    492
    Rep Power
    223
    no prob
    Domain Registration = RM35/Year com net org biz info us

  5. #5
    Join Date
    Nov 2001
    Location
    Johor
    Posts
    772
    Rep Power
    234
    alah x sempat lagi aku nak jwb. ngelat tul la ko zmiey
    I hate when:

    vBulletin Message:
    Sorry! The administrator has specified that users can only post one message every 60 seconds

  6. #6
    Join Date
    Apr 2002
    Location
    Cyberspace
    Posts
    492
    Rep Power
    223
    ko jawab aje la.. buat2 tak nampak jer dah terjawab ke blom
    Domain Registration = RM35/Year com net org biz info us

  7. #7
    Join Date
    Nov 2001
    Location
    Johor
    Posts
    772
    Rep Power
    234
    haha shiyol jerk

    ** closed
    I hate when:

    vBulletin Message:
    Sorry! The administrator has specified that users can only post one message every 60 seconds

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Be A Malaysian, Buy .my Domain name! Lowest Domain Price In Malaysia!
    By starsearcher in forum Web Hosting Offers
    Replies: 14
    Last Post: 10-11-2014, 10:32 AM
  2. Replies: 6
    Last Post: 15-09-2011, 03:52 PM
  3. Hive.com.my - RM110 a year (FREE domain name), Host minimum 5 domain names
    By Filuren in forum Paid Hosting Discussion Forum
    Replies: 0
    Last Post: 08-04-2004, 08:17 PM
  4. MYSQL : restore big dump file
    By or3o in forum Website Programming
    Replies: 20
    Last Post: 07-02-2004, 01:13 AM
  5. Hive.com.my - RM11 a month (FREE domain name), Host minimum 5 domain names
    By Filuren in forum Paid Hosting Discussion Forum
    Replies: 6
    Last Post: 03-01-2004, 02:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search Engine Optimization by vBSEO 3.5.0 RC1 PL1

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