5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Need Help Copying My Tables / Database

by fredjr1978
4 replies
Hello,

First I would like to say thank you to whomever is willing to help me out on this issue.

I am in the process of creating another website, but I want to use the same Tables / Database that I have in my current website.

I use cPanel and HTML to create my website. I have already made a template out of my website, but now I need to make sure to also turn my current tables / database into a .sql fil.

I have tried exporting the files into a .zip.sql file, but for some reason it is not working.

Please let me know if you have any other questions to help me in this process.

Regards,

Fred
#copying #database #tables
  • Profile picture of the author Istvan Horvath
    From cPanel click phpMyadmin.
    When there, on the left select the database you want to export.

    On the next page you will see at the top: Export.
    Click and export both the data and structure. Save it as file (at the bottom you have this option)

    It will start to download automatically a .sql file.

    At the new location you repeat the first steps... just instead of Export, you will Import the file from your hard disk.
    Signature

    {{ DiscussionBoard.errors[3053009].message }}
  • Profile picture of the author Istvan Horvath
    The less tables might be because the import is not complete... it stops where the error is happening.

    Googling your error message (without the number string) reveals a lot of possible issues:
    - old mysql version
    - number strings not being in quotes (<== this seems to be the most common!)
    - non-escaped characters in the tables

    It seems you will have to dig into it to resolve the error
    Signature

    {{ DiscussionBoard.errors[3053222].message }}

Trending Topics