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!
Thanks again!
Infopro
Well-Known Member
Re: Can someone pretty please give a step by step to import a 1 gig databas
I think this would work.
Back it up:
Restore it:
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
Code:
mysql -u dwhs_dwhs -p dwhs_wrdprss[B]B[/B] < /home/dwhs/workroom/dwhs_wrdprss1.sql| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| S | MariaDB Encryption at Rest: Steps to Implement? | Databases | 1 | |
| M | Error MySQL/MariaDB Upgrade (5.6 to 10.0) step 4 | Databases | 4 | |
| M | MySQL Upgrade (those 7 steps) | Databases | 8 | |
| M | How to install InnoDB (step by step) | Databases | 8 |