/ Register

Learn about Centmin Mod LEMP Stack today
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

    919
    191
    43
    Jun 30, 2017
    Ratings:
    +296
    Local Time:
    6:52 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

    59,274
    12,508
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,140
    Local Time:
    7:52 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    5:52 PM
    Mainline
    10.2
Previous Thread Next Thread
Loading...

.