MySql ERROR

Results 1 to 21 of 21
  1. #1
    Valued Member kombinho is offline
    MemberRank
    Nov 2011 Join Date
    121Posts

    MySql ERROR

    Hello everybody today I needed to create a new database in the admin and got the following error:
    Can not create database 'pw' (errno: 28) SQL command
    In fact this error was when I tried to create a new database.
    And whenever I try to modify an already created in the database (Error: 28), do not connect more phpmyadmin in the admin.
    Someone help me?

    I realized that the database is in use 100% as I do to increase the database or delete files to play it free without damaging the Pw?


  2. #2
    Fyyre Fyyre is offline
    MemberRank
    Oct 2007 Join Date
    EuropeLocation
    273Posts

    Re: MySql ERROR

    Error 28 means you are out of disk space. ( df from console will show what % of drive is full ) - try deleting some things you not need.

    -Fyyre

    Quote Originally Posted by kombinho View Post
    Hello everybody today I needed to create a new database in the admin and got the following error:
    Can not create database 'pw' (errno: 28) SQL command
    In fact this error was when I tried to create a new database.
    And whenever I try to modify an already created in the database (Error: 28), do not connect more phpmyadmin in the admin.
    Someone help me?

    I realized that the database is in use 100% as I do to increase the database or delete files to play it free without damaging the Pw?

  3. #3
    Valued Member kombinho is offline
    MemberRank
    Nov 2011 Join Date
    121Posts

    Re: MySql ERROR

    Yeah I've been giving some research and found that because of the space is the same, but as increased space?

  4. #4
    Proficient Member letanduy is offline
    MemberRank
    Nov 2011 Join Date
    192Posts

    Re: MySql ERROR

    I got this problem and it is fixed!
    1/ U can delete something in /PWServer/logservice/logs (like world2.log) and create one, dont forget chmos 0777 this file.

    2/ To increased virtual disk space (using VmWare) following these steps:
    - Use VmWare tool to Expand the virtual disk, look at the picture:


    - Download ubuntu 11.10 desktop I386: http://mirrors.digipower.vn/ubuntu/r...sktop-i386.iso
    - Create new virtual machine with this ubuntu iso file
    - Add the PW-Server virtual disk file into this machine (dont forget backup one).


    - In the first boot, go to bios config and setup boot from cd room first.


    - And now, reboot your machine nomaly, and chose Try Ubuntu.
    - When finish booting, use Gparted tool as a partation tool to increase disk place (dont forget chose your PW-Server virtual disk).

    Hope these infos can help u^^!

  5. #5
    Valued Member kombinho is offline
    MemberRank
    Nov 2011 Join Date
    121Posts

    Re: MySql ERROR

    I use vbox can not teach me in vbox?
    And if you can explain to me how I delete the World2 no bug!
    Thank you!

  6. #6
    Black Magic Development das7002 is offline
    MemberRank
    Apr 2010 Join Date
    EarthLocation
    2,188Posts

    Re: MySql ERROR

    His way is insanely overcomplicated anyway... Create another virtual hdd that is larger then just use dd to copy everything to it and delete the old drive. (you may need to update grub config)
    Posted via Mobile Device

  7. #7
    Angelemu founder tbnanubis is offline
    MemberRank
    Mar 2011 Join Date
    Unicorn ForestLocation
    527Posts

    Re: MySql ERROR

    add the world log and trace to logrotate service and let it zip up once a week oO

  8. #8
    Proficient Member letanduy is offline
    MemberRank
    Nov 2011 Join Date
    192Posts

    Re: MySql ERROR

    Quote Originally Posted by kombinho View Post
    I use vbox can not teach me in vbox?
    And if you can explain to me how I delete the World2 no bug!
    Thank you!
    I dont use vbox so i dont know. I think it is the same
    In VmWare, i can delete world2.log and create another world2.log file (this file is null) and chmos 0777. No bug!

  9. #9
    Black Magic Development das7002 is offline
    MemberRank
    Apr 2010 Join Date
    EarthLocation
    2,188Posts
    Quote Originally Posted by tbnanubis View Post
    add the world log and trace to logrotate service and let it zip up once a week oO
    That too.. It's so easy to do too...
    Posted via Mobile Device

  10. #10
    Valued Member kombinho is offline
    MemberRank
    Nov 2011 Join Date
    121Posts

    Re: MySql ERROR

    Yes I did delete the file just fine but I still think the same problem can happen there would be great if possible increase the memory ...

  11. #11
    Omega 343 is offline
    MemberRank
    Oct 2009 Join Date
    Ancient DGN CTYLocation
    5,514Posts

    Re: MySql ERROR

    I advise getting VMware, it is much better than vbox

  12. #12
    Valued Member kombinho is offline
    MemberRank
    Nov 2011 Join Date
    121Posts

    Re: MySql ERROR

    Its I transfer my machine for vmware?

  13. #13
    Proficient Member letanduy is offline
    MemberRank
    Nov 2011 Join Date
    192Posts

    Re: MySql ERROR

    I think both are the same. Create virtual machine in vbox with Ubuntu desktop 11.10 i386.iso file, and start machine, use gparted tool to increase the virtual disk place

  14. #14
    Fyyre Fyyre is offline
    MemberRank
    Oct 2007 Join Date
    EuropeLocation
    273Posts

    Re: MySql ERROR

    Quote Originally Posted by 343 View Post
    I advise getting VMware, it is much better than vbox
    VMware has better snapshot system, and support for drag and drop files from host to guest.

    Vbox support for ACPI 2.0, open source and free.

    -Fyyre

  15. #15
    Valued Member kombinho is offline
    MemberRank
    Nov 2011 Join Date
    121Posts

    Re: MySql ERROR

    There is no way I transfer vbox to vmware PWServer without modifying the files?

  16. #16
    Black Magic Development das7002 is offline
    MemberRank
    Apr 2010 Join Date
    EarthLocation
    2,188Posts

    Re: MySql ERROR

    Just set it back up in VMware. (it should support VDI disks) No idea why you would want to do that though... Virtualbox is so much better then VMware
    Posted via Mobile Device

  17. #17
    Nerd-IO Romulan is offline
    MemberRank
    Feb 2009 Join Date
    BelgiumLocation
    3,333Posts

    Re: MySql ERROR

    Quote Originally Posted by das7002 View Post
    Virtualbox is so much better then VMware
    Posted via Mobile Device
    +1

  18. #18
    Black Magic Development das7002 is offline
    MemberRank
    Apr 2010 Join Date
    EarthLocation
    2,188Posts
    Quote Originally Posted by Romulan View Post
    +1
    Hey! Welcome back Romulan.
    Posted via Mobile Device

  19. #19
    Omega 343 is offline
    MemberRank
    Oct 2009 Join Date
    Ancient DGN CTYLocation
    5,514Posts

    Re: MySql ERROR

    You guys have it the WRONG way around

    It's -- VMware is BETTER than Vbox

    //facepalm

    Quote Originally Posted by Fyyre View Post
    VMware has better snapshot system, and support for drag and drop files from host to guest.

    Vbox support for ACPI 2.0, open source and free.

    -Fyyre
    VMware player IS free now

  20. #20
    Black Magic Development das7002 is offline
    MemberRank
    Apr 2010 Join Date
    EarthLocation
    2,188Posts

    Re: MySql ERROR

    And that is only because VMware was actually afraid of how awesome Virtubox is!
    Posted via Mobile Device

  21. #21
    Omega 343 is offline
    MemberRank
    Oct 2009 Join Date
    Ancient DGN CTYLocation
    5,514Posts

    Re: MySql ERROR

    HA, nice one man; I almost fell out of my chair :rofl:



Advertisement