Overwrite mysql


#1

i need to place a corrected db into a mysql db thru phpadmin.
i keep getting an answer back “file already exists”…
is there some way that i am mising of deleting content of the db and starting over again with it??


#2

[quote] need to place a corrected db into a mysql db thru phpadmin.
i keep getting an answer back “file already exists”…
is there some way that i am mising of deleting content of the db and starting over again with it??[/quote]
The file is an .sql dump file right? Are you familiar with using shell access instead of PHPMyAdmin?

Customer since 2000 :cool: openvein.org


#3

i know what putty and ssh are…that;'s all.
the existing file was imported as .txt into the db
i am atempting to do th same again…with the above repoirted trouble.

“dumping” sounds lijke the right idea…
i thought an “overwrite” would work if mysql would let me do it.


#4

[quote]“dumping” sounds lijke the right idea…
i thought an “overwrite” would work if mysql would let me do it.[/quote]
To “overwrite” a table you can use PHPMyAdmin to “Empty” the table. If your SQL dump creates a table, you can also “Drop” the table after you “Empty” it. You can’t add or “Drop” databases using PHPMyAdmin, that has to be done using the DreamHost Web Panel.

The best way to import an SQL dump is through the command line in a shell, because it is more direct with less caveats:

http://wiki.dreamhost.com/Migrate_MySQL#Importing_Through_the_Shell

Customer since 2000 :cool: openvein.org


#5

Thanks guys, this thread was very helpful to me.