blindpet

mysqldump -u [user] -p[password] [database] [table] > [output_file_name].sql

mysqldump -p --user=example --where="x = 'y' AND id = 2" dbname tablename >> dump.sql
#dumping last rows
mysqldump -uroot -p db_name table_name --where='id<1000000'
or you can use

SELECT * INTO OUTFILE 'data_path.sql' from table where id<100000

blindpet

server {
        server_name default_server;

        access_log   /var/log/nginx/htpcguides.com.access.log;
        error_log    /var/log/nginx/htpcguides.com.error.log;

        root /var/www/htpcguides.com/;
        index index.php;

        location / {