backup and executing sql from source

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

backup and executing sql from source

Post by neophyte »

I've backed up my sql by using dump via phpmyadmin. I have found that when I try to execute the sql with a source somesql.sql command that it always generates errors. The culprit seems to be the pesky -- comments inserted through out the text. I'm trying to copy tables from my internet server to a test environment. How do I avoid this? Am I going about this all wrong? Is there a better faster way?
Post Reply