Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 02-04-2016, 10:07 PM
Abronsyth's Avatar
Abronsyth Abronsyth is offline
A Headache Embodied
 
Join Date: Aug 2011
Location: NY
Posts: 1,011
Gender: Male
Credits: 111,766
Abronsyth is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 02-04-2016, 10:09 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 327,837
Hall of Famer is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 02-04-2016, 10:31 PM
Abronsyth's Avatar
Abronsyth Abronsyth is offline
A Headache Embodied
 
Join Date: Aug 2011
Location: NY
Posts: 1,011
Gender: Male
Credits: 111,766
Abronsyth is on a distinguished road
Default

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)
Reply With Quote
  #4  
Old 02-04-2016, 11:21 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 327,837
Hall of Famer is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 02-05-2016, 12:06 AM
Kyttias's Avatar
Kyttias Kyttias is offline
Premium Member
 
Join Date: Jan 2014
Posts: 857
Gender: Unknown/Other
Credits: 87,045
Kyttias is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 06:57 AM.

Currently Active Users: 660 (0 members and 660 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636