mysqldump -h localhost --port=3306 -u phillip --password=password students blah | mysql -h localhost --port=3306 -u phillip --password=password -C archives
Super simple thing.. I want to copy the students.blah table to the archives database. Whenever I do it, it creates 2 tables, "blah" and "students_archive", which isn't references. This even after "DROP DATABASE archives" it STILL does it! And no data is ever backed up from the original "blah" table (or the "student_archives" table for that matter)
This is time sensitive and has to be working before 5pm EST today!
Needless to mention I'm stressed
Thanx
Phil