The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Step by step to import a 1 gig database?

Discussion in 'Database Discussions' started by DWHS.net, Jan 31, 2013.

  1. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Thanks, it's a cpanel server and obviously phpmyadmin cannot import a 1 gig DB. So I was hoping for a cut and paste or basic tutorial on uploading it to root and importing it inot a already made database.

    Thanks again!
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Re: Can someone pretty please give a step by step to import a 1 gig databas

    I think this would work.
    Back it up:
    Code:
    mysqldump --opt -Q -u dwhs_dwhs -p dwhs_wrdprss[B]A[/B] > /home/dwhs/workroom/dwhs_wrdprss1.sql
    Restore it:
    Code:
    mysql -u dwhs_dwhs -p dwhs_wrdprss[B]B[/B] < /home/dwhs/workroom/dwhs_wrdprss1.sql
     
Loading...

Share This Page