There are a couple of different ways, depending on your database type and how you interact with it. If you use phpMyAdmin, it is trivial to export a table or tables to a .sql file. then you can either import directly via phpMyAdmin on the server, or if you have command line access on the server you can just run 'source $file' where $file is the full path to the .sql file saved on the server.