I have over 15,000 records within a local mySQL table. I need to create a dump file so that I may insert these into a mySQL table on a web server.
Does anyone know the code to product a dump file?
Thanks in advance.
Use this command from the shell.
mysqldump db_name table_name > file.sql
where file.sql is the name that you choose, and is a text file, so you can read or transfer or whatever.
Sorry, i forgot to show how to load the dumped file in a data base.
mysql db_name < file.sql
