Transferring Databases?

[Abronsyth]

Resolved

Hoping someone could help me with this...I don't really know mySQL well at all, so I'm not sure about how to do this. I'm moving to a new host so that my site can continue to grow and so that I can have a domain name. However, I have no idea how to move my database data to the new host.

Does anyone here know how to do this?

[Hall of Famer]

You can go to phpmyadmin, and use the export option to acquire a database SQL file(DB dump).

[Abronsyth]

Unfortunately I have a limit of 64 mb, and the database accumulates to 71mb ;n;

Not far over the limit though...so perhaps I can figure out where I can slim it down a bit.

[Hall of Famer]

A simple way to trim down the database size is to remove data from table prefix_vote_voters. This table stores a lot of data, and most aint very useful.

[Kyttias]

You should be able to export a few individual tables, delete them, and then try backing up the rest. It's really dumb that there's a limit, considering it just kind of spits it all out in a plain text format.