#1
|
||||
|
||||
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?
__________________
My Mods Site (1.3.4, 2020 Mods) Last edited by Abronsyth; 02-18-2016 at 02:47 PM. |
#2
|
||||
|
||||
You can go to phpmyadmin, and use the export option to acquire a database SQL file(DB dump).
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#3
|
||||
|
||||
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.
__________________
My Mods Site (1.3.4, 2020 Mods) |
#4
|
||||
|
||||
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.
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#5
|
||||
|
||||
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.
__________________
Please do not contact me directly outside of Mysidia.
I also cannot troubleshoot code more than two years old - I legit don't remember it. |
Thread Tools | |
Display Modes | |
|
|
What's New? |
What's Hot? |
What's Popular? |