Want more timely Centmin Mod News Updates?
Become a Member

Question about phpmyadmin

Discussion in 'System Administration' started by Jon Snow, Jun 8, 2021.

  1. Jon Snow

    Jon Snow Active Member

    617
    112
    43
    Jun 30, 2017
    Ratings:
    +171
    Local Time:
    5:23 AM
    Nginx 1.13.9
    MariaDB 10.1.31
    This is a question for people who work with large databases who don't have SSH access.

    How do you import/export a large database with phpmyadmin?


    Do you split it up? What do you use to split it up and how do you confirm it's OK? Is it even a good decision to go the route of splitting it up?
     
  2. eva2000

    eva2000 Administrator Staff Member

    46,851
    10,627
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,493
    Local Time:
    6:23 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    No one with large databases should use phpmyadmin at all for exporting databases. Risk of incomplete data is much higher. I've never ran a site where I didn't have full SSH control - being a control freak that I am.

    If you have data that is important to you, then I'd look at moving to a server with SSH access - otherwise timely access to you data is limited.
     
  3. rdan

    rdan Well-Known Member

    5,062
    1,249
    113
    May 25, 2014
    Ratings:
    +1,894
    Local Time:
    4:23 PM
    Mainline
    10.2