Web Hosting Talk







View Full Version : sql backup


nachopo
04-09-2003, 12:35 AM
hi.
I used phpmyadmin for make a backup for an sql database but my customer have problems when they import this backup because lines are too long, so they ask me to send sql files. He told me that they are at /var/lib/mysql/domainname_com/ etc.

Im a reseller and I do not have shell access. How I can get this files ?
regards

Southernman
04-09-2003, 12:49 AM
In phpmyadmin, you can do a dump of the database, into an sql file.

Login to phpmyadmin, select the database, click the SQL link at the top of the page, check all tables, select structure and data, and click submit.

That should give you the sql file he's asking for without having ssh. At least I think thats right without looking at phpmyadmin myself while writing this.

CMH
04-09-2003, 02:46 AM
do you have telnet access?

If so just log in and use the following command

mysql -u USERNAME -p'MYSQLPASSWORD' DATABASENAME < /HOME/DIR/TO/DUMP.SQL

Replace the USERNAME (everything in caps) and such with correct info though.