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

    644
    125
    43
    Jun 30, 2017
    Ratings:
    +186
    Local Time:
    12:18 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

    48,977
    11,224
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,474
    Local Time:
    1:18 AM
    Nginx 1.21.x
    MariaDB 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 Premium Member Premium Member

    5,299
    1,326
    113
    May 25, 2014
    Ratings:
    +2,050
    Local Time:
    11:18 PM
    Mainline
    10.2