import sql database

[scott streed]

I used the below to create and compress a backup of my mysql JIRA database:

     #mysqldump -u jiradbuser -p  jiradb | gzip -9 > backupjiradb.sql.gz

To uncompress:

   #gunzip backupjiradb.sql.gz

How do I restore the backup?

    #mysql -u jiradbuser –p jiradb < backupjiradb.sql                      does not work?

[Nic Brough -Adaptavist- · Accepted solution]

It's not an "import", it would be an "over write".  The source and target versions of JIRA would need to be identical for it to work as well.