This is probably a simple process but i've being having no luck with it and need to taken care of quickly.
I currently have a live magento store (on mysql database) and i would like the copy the database in order to create a clone of the site for testing purposes. The problem is that when i choose to export the database with phpmyadmin it spits out a file that's over 50mb. I cannot import this because my shared hosting won't allow me to upload files greater than 2mb. So what i need simply is the following
-Copy my SQL database to another on the same server
-Provide a step by step as to how this was achieved
I have SSH, FTP and cpanel access and i'm looking to spend no more than $30 as i suspect that is it a quick procedure using SSH