/ Register

Welcome to Centmin Mod Community
Become a Member

Question about phpmyadmin

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

Previous Thread Next Thread
Loading...
  1. Jun 8, 2021 #1
    Jon Snow

    Jon Snow Active Member

    835
    170
    43
    Jun 30, 2017
    Ratings:
    +256
    Local Time:
    8:14 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. Jun 8, 2021 #2
    eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    10:14 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Jun 8, 2021 #3
    rdan

    rdan Well-Known Member

    5,446
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    8:14 PM
    Mainline
    10.2
Previous Thread Next Thread
Loading...

.