Find the answer to your Linux question:
Results 1 to 4 of 4
Hi, I want to get MySQL backup with views. MySQL server is hosted on Fedora 13 Server. Currently I use ; mysqldump -u root -pPW dbname > db.dump command in ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie amithad's Avatar
    Join Date
    Sep 2006
    Location
    Sri Lanka
    Posts
    160

    Question How to get MySQL Backup with Views?


    Hi,

    I want to get MySQL backup with views. MySQL server is hosted on Fedora 13 Server. Currently I use ;

    mysqldump -u root -pPW dbname > db.dump
    command in a shell script to get backups daily. But when I restore the DB in developer (WinXP) pc the views are not restoring

    what should I do to get views in the backup?


    Thanks

  2. #2
    Linux Enthusiast
    Join Date
    Aug 2006
    Location
    Portsmouth, UK
    Posts
    539
    Have you checked to see if the views are in the backup, but not being created on restore?
    Exporting (dumping) VIEWs Using mysqldump — mysqlhacker This link is old (200, but discusses issues with views and permissions / host restrictions.
    RHCE #100-015-395
    Please don't PM me with questions as no reply may offend, that's what the forums are for.

  3. #3
    Linux Newbie amithad's Avatar
    Join Date
    Sep 2006
    Location
    Sri Lanka
    Posts
    160

    Thumbs up

    Quote Originally Posted by matonb View Post
    Have you checked to see if the views are in the backup, but not being created on restore?
    Exporting (dumping) VIEWs Using mysqldump — mysqlhacker This link is old (200, but discusses issues with views and permissions / host restrictions.
    Dear Matonb,

    Thanks for your reply ! I tried resoring the MySQL dump using commandline( Instead of MySQL Administrator) then got an error like
    MySQL : "The user specified as a definer ('root'@'%') does not exist"
    Searched the similar error and apply the command
    grant all on *.* to 'root'@'%' identified by 'password' ;
    It worked fine all the views are there now

    Thanks

  4. #4
    Linux Enthusiast
    Join Date
    Aug 2006
    Location
    Portsmouth, UK
    Posts
    539
    You're most welcome ,
    can you tag this thread as solved?
    RHCE #100-015-395
    Please don't PM me with questions as no reply may offend, that's what the forums are for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •