Jump to content

How do I dump an SQL DB to a webpage when you only have sql and ftp passwords


Dethman

Recommended Posts

I need to get all of the  SQL without having to go into PHPMYADMIN I have SQL DB Passwords and FTP is there any type of script that will dump the SQL onto like an HTML page so all I have to do is go to this php page and make a backup of SQL untill my new password gets in for my CPanel?

try

SELECT * FROM table_name ORDER BY id  //assuming you have one

 

then print each column in a foreach loop

 

do that for each table and you will get the whole database, then you get to spend hours copy pasting it into a formatted file

 

OR you could create a csv from the db and then it will dl into a useable format

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.