Quote:
Originally posted by Zorgman
Upload the 50MB file to your webserver and use ssh or telnet to insert it into the mysql database.
mysql -u username -p databasenamee < filename.sql
Also for reference - backing up
mysqldump -u username -p databasename > dumpfile.sql
It's been a while since I used this way, I hope it hasn't changed at all. 
|
Thanks for the feedback but I'm still in the dark.
I do not have the sql file on my local computer. The only file on the MySQL database I have found is a .myd file that's 52Mb
How do I create the sql file with the database inserts to upload to the server. The export feature on PHPMyAdmin does not seem to work with so many records.
Also I have no idea about where to upload the SQL file