I have 1GB database that needs to be uploaded to my dev server(phpmyadmin). Is there any solution upload? Please do help me by providing the steps to upload the mysql file. i can't use SQlyog,Putty because i have just cpanel information.
How to use:
Upload /sxd/ folder to your site.
Upload database dump into /sxd/backup/ folder. I know you can't use ssh, but surely ftp transfers must be available for your plan.
Open yoursite.com/sxd/ folder, login with MySQL credentials.
Click "Import" button in upper left corner.
Choose database to where you want to restore dump.
Charset - set necessary or leave
File - in this select field there will be files that are uploaded to /sxd/backup/. Choose necessary.
Press "Execute" button in lower right corner.
Wait for import process to finish. Note: sometimes progress bar may show incorrect percentage (i.e. 100% from the start).