Join the community today
Become a Member

Question about phpmyadmin

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

  1. Jon Snow

    Jon Snow Active Member

    618
    114
    43
    Jun 30, 2017
    Ratings:
    +173
    Local Time:
    9:09 PM
    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

    47,223
    10,673
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,582
    Local Time:
    10:09 AM
    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,074
    1,253
    113
    May 25, 2014
    Ratings:
    +1,905
    Local Time:
    8:09 AM
    Mainline
    10.2