why does wordpress db not export correclty?

unwashed potato! · 4 Oct 2009 at 18:41

i don't understand what i'm doing wrong here. i have xampp installed on my pc which i'm working on a wordpress blog. i click export in phpMyAdmin to the wordpress database, copy all the files. i then imported the sql file on my laptop and copied the wordpress files to the exact same location, however the information isn't exported pproperly, e.g. the permalink settings are incorrect and only the first 10-20 words of each article is copied.

anyone know why this happens? i can't see how else i'd get it to go across correctly

brainchylde · 4 Oct 2009 at 19:52

PhpMyAdmin has a problem exporting sometimes. You should try exporting from the command line using mysqldump command

unwashed potato! · 4 Oct 2009 at 21:25

brainchylde said:
PhpMyAdmin has a problem exporting sometimes. You should try exporting from the command line using mysqldump command

really? that seems a little unrealistic as surely it's a rather simple thing? you'd think if they offer to export your database that they'd do it well given its popularity.

brainchylde · 4 Oct 2009 at 23:24

I've had this problem myself. In work we use a number of MySQL databases. I once had to move the databases from one server to another.. I tried exporting from PhpMyAdmin and when I re-imported (although it did re-import) a lot of things had lost their formatting.

The way I got around it was using the command line.