+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: this is my first question to this site , maybe you can solve it .

  1. #1
    coolaki6086 is offline x10Hosting Member coolaki6086 is an unknown quantity at this point
    Join Date
    Sep 2011
    Posts
    9

    this is my first question to this site , maybe you can solve it .

    hello everyone i am new to this site .. i found this site very handy, this is my first question to this site , maybe you can solve it , earlier i was on some other hosting which was not great... all i want to ask you guys is , i have a backup of my website in sql format .. how to restore that backup in my site on these hosting,, i already added the domain in these hosting but dont know how to restore the backup data (which is in sql format) under my site.

  2. #2
    wongers's Avatar
    wongers is offline x10 Lieutenant wongers is an unknown quantity at this point
    Join Date
    Nov 2009
    Location
    Leeds, England
    Posts
    432

    Re: this is my first question to this site , maybe you can solve it .

    I believe there is a function to restore data inside the PHPMyAdmin function inside the user cpanel section. i might be wrong, can someone else help on this one??

  3. #3
    theone48's Avatar
    theone48 is offline x10 Sophmore theone48 is an unknown quantity at this point
    Join Date
    Jun 2011
    Posts
    221

    Lightbulb Re: this is my first question to this site , maybe you can solve it .

    coolaki,

    1) Login to your hosting control panel and scroll down to the heading Databases.
    2) Click the icon phpMyAdmin. A new webpage will open.
    3) Scroll to more on the header and select import from the drop-down list. Follow on screen instructions.

    Good luck!

  4. #4
    ChatIndia's Avatar
    ChatIndia is offline Community Advocate ChatIndia is on a distinguished road
    Join Date
    Sep 2009
    Location
    Exam Time. I won't tell you
    Posts
    1,320

    Re: this is my first question to this site , maybe you can solve it .

    I think you need to create a blank database first in order to import things.
    Your appreciation is extremely Important. Click on the button at the bottom left corner of my post.

  5. #5
    coolaki6086 is offline x10Hosting Member coolaki6086 is an unknown quantity at this point
    Join Date
    Sep 2011
    Posts
    9

    Re: this is my first question to this site , maybe you can solve it .

    i created blank database but its not working.importing of the db is successful but i cannot see my website restored.

  6. #6
    ChatIndia's Avatar
    ChatIndia is offline Community Advocate ChatIndia is on a distinguished road
    Join Date
    Sep 2009
    Location
    Exam Time. I won't tell you
    Posts
    1,320

    Re: this is my first question to this site , maybe you can solve it .

    haha, i mean that you need to create a blank database and then upload the sql file inside that database.
    Your appreciation is extremely Important. Click on the button at the bottom left corner of my post.

  7. #7
    coolaki6086 is offline x10Hosting Member coolaki6086 is an unknown quantity at this point
    Join Date
    Sep 2011
    Posts
    9

    Re: this is my first question to this site , maybe you can solve it .

    yes i did it thanks for your reply but it didnt completely restored my data back kittenstrainig.com visit and tell me what else can i do with it whenevr i try to go in categories it just shows dosent exist

  8. #8
    ChatIndia's Avatar
    ChatIndia is offline Community Advocate ChatIndia is on a distinguished road
    Join Date
    Sep 2009
    Location
    Exam Time. I won't tell you
    Posts
    1,320

    Re: this is my first question to this site , maybe you can solve it .

    now the database name, username and password will change according to your new database that you had created just now. did you change those parameters on your config.php file?
    Your appreciation is extremely Important. Click on the button at the bottom left corner of my post.

  9. #9
    coolaki6086 is offline x10Hosting Member coolaki6086 is an unknown quantity at this point
    Join Date
    Sep 2011
    Posts
    9

    Re: this is my first question to this site , maybe you can solve it .

    see first i just installed wp and then leaved it because without installing wp even though i restore the db successfully it was not showing in the site , i had given different pass earlier , but when i imported the backup db it automatically went on to the previous username and pass.

    ---------- Post added at 04:39 AM ---------- Previous post was at 04:38 AM ----------

    what i was thinking that deleting everything and then again install wordpress with the same pass and username as it was earlier .?

    ---------- Post added at 04:42 AM ---------- Previous post was at 04:39 AM ----------

    and i kept the db name same as it was earlier

    ---------- Post added at 04:45 AM ---------- Previous post was at 04:42 AM ----------

    because without keeping the db name same i would not had able to resoter my db

    ---------- Post added at 05:18 AM ---------- Previous post was at 04:45 AM ----------

    ok so i deleted everything under my domain and installed the wordpress with the same db name , username and pass but still its the same www.kittenstraining.com , i can see all of my posts in the php admin under database name where i restored my db, but they are not appearing in the website, what should i do?also all the themes and plugins are gone .

  10. #10
    Dead-i's Avatar
    Dead-i is offline Community Advocate Dead-i has a spectacular aura about
    Join Date
    Aug 2011
    Location
    United Kingdom
    Posts
    1,448

    Re: this is my first question to this site , maybe you can solve it .

    You need to use the following MySQL Configuration information. Make sure this information is correct. Some of the information vary:
    Hostname: localhost
    Username: CPANELUSER_MYSQLUSER (your cPanel username, then an underscore, then the MySQL user you created)
    Password: MYSQLPASS (the MySQL user password you created)
    Database: CPANELUSER_MYSQLDB (your cPanel username, then an underscore, then the MYSQL Database Name you created)
    Table Prefix: (look at the tables in your database; they might all have a prefix like wp_. Type that here)

+ Reply to Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. my site masti4m.org plss solve its error sir plsss
    By er.shekhar007122 in forum Free Hosting
    Replies: 2
    Last Post: 08-08-2010, 03:55 PM
  2. please solve this one
    By vsshanmuhasundar28 in forum Free Hosting
    Replies: 1
    Last Post: 06-05-2010, 06:18 AM
  3. Quick starter question, anyone here can solve this!
    By xadeevents in forum Introductions
    Replies: 1
    Last Post: 07-01-2009, 07:07 PM
  4. Can anyone solve this question in C programming Language?
    By Stella Richards in forum Programming Help
    Replies: 3
    Last Post: 04-15-2009, 02:51 PM
  5. Replies: 1
    Last Post: 03-10-2009, 07:23 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers