How to dump database using mysql (no mysqldump on server)

You can use the following methods (from Database Backups in the documentation)

Creating backups by copying files

MyISAM tables are stored as files, so it's easy to back up by copying the files. To get a consistent backup, make LOCKING TABLES on the respective tables, followed by FLUSH TABLES for the tables. You only need a read lock; this allows other clients to keep querying tables while copying files to the database directory. The FLUSH TABLES statement is required to ensure that all active index pages are written to disk before starting the backup.

FLUSH TABLES WITH READ LOCK;

      

        
        
        
      

    

Closes all open tables and locks all tables for all read-locked databases until you explicitly release the lock by executing UNLOCK TABLES. This is a very convenient way to get backups if you have a file system like Veritas that can take snapshots.

UNLOCK TABLES;

      

        
        
        
      

    

Create delimited backups

To create a text file containing table data, you can use:

SELECT * INTO OUTFILE 'file_name' FROM tbl_name

      

        
        
        
      

    

This method works for any data file, but only stores the table data, not the table structure.

To reload the output file use "

LOAD DATA INFILE