I’ve had issues from time to time where a sql file won’t import because if has a definer in it that doesn’t match the server I’m trying to import the file to. A simple linux command can replace the definer in these dump files to be the current user allowing everything to work as intended….
Here’s the sql I use when creating a database for an app where it’s assumed each table will have columns that store unix time stamps for their created date and time, and updated date and time. It assumes that there is a column named created and one named updated on the table. [code] create trigger…
Sometimes you need to copy a database to a dev database or something. You can usually do this through phpmyadmin, but it’s so much faster, especially with large databases, to do it through command line. Once ssh’d into a server with mysql on it, create a new database for the one you’re going to import…
[code language=”sql”] UPDATE table SET column = replace(tablefield, "search", "replace"); [/code]