lunchmeat

Uploading this file in chucks sounds like a great idea (I'm assuming that you are talking about via the phpmyadmin web tool). If this is the case... > How/where would I bring these files back together? >What tool can I use to break up this file? Like I mentioned earlier, when I run the command line, it then asks me for a password. What password is it looking for? Thanks for taking the time to answer some of my questions.

Alright, from the top... ??? Recently, I just moved my Wordpress blog from one hosting company to another. By following some instructions via the Wordpress website, I got to the part which asked me to upload my old .sql file. Using phpMyAdmin 2.6.2-pl1 I then click on the SQL icon to upload the database file. The problem, it only can upload files 8M and smaller (and my file is about 50M). I noticed just below the browse window a radio button for gzipped, so I gzip my file to just under 8M. When I upload it, it still times out on me. Tech support suggested I use ssh (deep waters for me without a lifeboat in site). He gives me this command to use: [b]mysql -u USERNAME -p PASSWORD -h HOST localhost < your-file.sql[/b] (let me stop right here. Is 'username' the username of the new sql server or is it the username of the sql file? I've tried both. For password, I have been using the password of my new database server.) Anyway, when I execute this command, it then prompts me for a password. Is this the password of the .sql file that I am trying to upload? I have tried all passwords that I could think of and it is not taking it. Mind you, the support from my previous support company sucks so bad, asking them for this information would be like asking someone for the location of the WMDs. My hunch is that the same user/password imy former hosting company issued to me for ftp access would be the same user/pass for my database (since I have never had a need to access/change it). In the meantime, I have been stuck in this neverending loop that keeps asking me for a password. Thank you for your time. If you can respond to this in dummieese, I would appreciated.