loading large php tables

Discussion in 'Installation/Configuration' started by Boon-Dog-Danny, Sep 4, 2006.

  1. Boon-Dog-Danny

    Boon-Dog-Danny New Member

    hi,

    can someone tell me how to load the really large php tables into the phpmyadmin using the terminal.. I think Till mentioned in a forum about the phpmyadmin not having a zip compiled.. something about you can use the terminal to load . anyone know how to do this



    debian sarge 3.1 ispconfig 2.2.6 phpmyadmin 2.6.4-pl3
     
    Last edited: Sep 4, 2006
  2. Ben

    Ben ISPConfig Developer ISPConfig Developer

    I guess you mean mySQL tables because php has no tables ;)

    Well if you have your dumpfile just run mysql.

    e.g. mysql -u youruser -p < yourdumpfile.sql

    This will connect to mysql with the user "youruser" and prompt for your password and afterwards paste the stuff from yourdumpfile... Even here you have no real zipsupport. Either you unzup your file first or you "pipe a bit around and try concatenating all commands in one line".
    Maybe you have to define the database name (i think) with -D database if the database select statement is not included in your dumpfile
     
  3. falko

    falko Super Moderator ISPConfig Developer

Share This Page