I need help uploading a 120mb database to myphpadmin... right now it keeps timing out! Any suggestions?
Nintendo, when I upload the sql file to the server. Do I upload it to the ip address root? or you mean the server root to which I'm uploading this specific website too? I have questions about this run command but I need to learn shh I guess. What does this run command do? mysql -uroot -pPASSWORD databasename < /public_html/file.sql -f Code (markup):
This command restores the database from the dump. All you need is to upload the file via FTP and then run this command as it is really the simplest way to import the database dump
You upload it exactly the same way you would upload anything else. The command does exactly what you're trying to do, upload a file in to a mySQL database.
Should I be forwarding my domain name to that root before proceeding? Also you're talking about the websites folder root right? or are you talking about some other root? I have many roots! when I typed that command into my SHH I got the following message. no such file or directory! The database I'm trying to restore is not active on the domain name yet I just created it! Should I set the DNS for this specific website before trying this command? Obviously I'm confusing what root to upload this sql file too! Please bear with me I'm a huge noob! can you show me an example if I was using the following information database, coolexample.com username, coolexample.com password, coolexample.com unsure of what root I'm using as well! Are we talking the domain name ftp root, my ip address ftp root?