SQL exports only have of my database
- Home
- Board: /g/ - Technology
- Reading: SQL exports only have of my database
Alright /g/ hopefully someone can help me out. When I export my SQL database it only exports like half of it.
It may be because there are over 1.5 million entries in the database.
Does anyone know how I can export the entire database?
My only other option would be to export it piece by piece but that won't help me when I need to make backups.
Are you using mysqldump? It won't care how big your DB is.
>>54614175
I have been trying to export it through phpmyadmin. I will have to try that though.
>>54614243
Yeah there's your problem. Also if this is important and you're not doing automatic backups you're going to have a bad time. Check out the automysqlbackup script.
>>54614243
>I have been trying to export it through phpmyadmin
The php script has probably been either running out of memory (they have memory limits) or running for too long (they have time limits) which is why you're getting half the data.
phpmyadmin is not made for big databases.
>>54614243
Prolly have max export filesize set to HALF the actual size of your db.
>>54614263
>>54614292
>>54614302
The only reason is I use phpmyadmin is because godaddy already has it integrated. By the way go daddy is like the fucking worst!
>>54614156
need more deditated wam
>>54614739
Yeah man it's 2016 and no one uses shared hosting anymore since you can get a digital ocean or linode VPS for $5/mo.
>>54614807
Vultr VPSs are also Digital Ocean-tier cheap, so there's that to consider. It gets bonus points for letting you deploy arbitrary ISOs (even downloaded server-side from the Internet), rather than only allowing their own pre-made OS images.
