I'm trying to transfer a blog to another server. I've exported the SQL, and then tried to import it on the other server, and am getting an error: Both servers are running mysql v4.1.x Any ideas?
Perhaps, you already have a table wp_categories in the database. Try dropping the table and then import.
Hey lapsaJ, If you're trying to simply MOVE the blog to another server, there are three simple steps. 1) SQL backup + restoration 2) FTP backup + restoration 3) Configuration changes The FTP backup consists in simply moving all the files from one side to another, careful in moving the .htaccess as well and setting the appropriate permissions afterwards (a 777 chmod on /uploads and .htaccess, 644 to config.php , etc). The SQL backup has two steps. First you export from the old database, with phpMyAdmin. Do not check anything, you simply don't need to modify anything in the phpMyAdmin Window (not even "drop if exists", you'll see later why). Just select all of the DB tables from the left, then check Save as file, Gzipped. On your other server, simply create a new database with nothing in it, and import the SQL file you got by exporting the old one. Everything will go smooth without errors. The last step, edit wp-config.php iwth your new database's information and you're all set. Hope this helps