Transferring Databases?
 

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?

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

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.

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.

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.